From a 500-row sample across 6 columns.
dolocationidpulocationiddolocationidpulocationiddolocationidpulocationiddolocationidpulocationiddolocationid| dispatching_base_num | pickup_datetime | dropoff_datetime | affiliated_base_number | dolocationid |
|---|---|---|---|---|
| B00009 | 2025-01-01T00:20:00.000 | 2025-01-01T00:57:00.000 | B00009 | — |
| B00013 | 2025-01-01T00:40:00.000 | 2025-01-01T02:21:00.000 | B00888 | — |
| B00112 | 2025-01-01T00:22:59.000 | 2025-01-01T00:45:28.000 | B00112 | 108.0 |
| B00112 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
dispatching_base_num | text | The TLC Base License Number of the base that dispatched the trip | 0% | B00412B02550B00856 |
pickup_datetime | datetime | The date and time of the trip pick-up | 0% | 2025-11-18T09:00:00.0002025-12-10T09:00:00.0002025-02-28T11:00:00.000 |
dropoff_datetime | datetime | The date and time of the trip dropoff | 0% | 2025-09-08T09:00:00.0002025-11-19T10:00:00.0002025-10-30T09:00:00.000 |
pulocationid | integer | TLC Taxi Zone in which the trip began | 82% |
GET /api/datasets/uigt-hi2k GET /api/datasets/uigt-hi2k/quality GET /api/datasets/uigt-hi2k/related GET /api/columns?dataset=uigt-hi2k
pulocationiddolocationidpulocationidpickup_datetimedropoff_datetimedolocationidpulocationid| 2025-01-01T00:32:57.000 |
| 2025-01-01T00:33:10.000 |
| B00112 |
| 14.0 |
| B00112 | 2025-01-01T00:46:48.000 | 2025-01-01T00:49:51.000 | B00112 | 14.0 |
| B00112 | 2025-01-01T00:56:32.000 | 2025-01-01T01:37:12.000 | B00112 | 91.0 |
| B00112 | 2025-01-01T00:12:46.000 | 2025-01-01T00:23:04.000 | B00112 | 14.0 |
| B00112 | 2025-01-01T00:35:07.000 | 2025-01-01T00:40:33.000 | B00112 | 14.0 |
| B00112 | 2025-01-01T00:09:31.000 | 2025-01-01T00:55:21.000 | B00112 | 14.0 |
| B00149 | 2025-01-01T00:10:18.000 | 2025-01-01T00:22:27.000 | B03136 | 35.0 |
206.0221.061.0dolocationid | integer | TLC Taxi Zone in which the trip ended | 15% | 265.076.0244.0 |
sr_flag | text | Indicates if the trip was a part of a shared ride chain offered by a High Volume FHV company (e.g. Uber Pool, Lyft Line). For shared trips, the value is 1. For non-shared rides, this field is null. | 100% | — |
affiliated_base_number | text | Base number of the base with which the vehicle is affiliated. This must be provided even if the affiliated base is the same as the dispatching base | 3% | B03404B01899B03164 |