From a 500-row sample across 6 columns.
dispatching_base_numpulocationiddolocationid+4dispatching_base_numpulocationiddolocationid+3dispatching_base_numpulocationiddolocationid+3dispatching_base_numpulocationiddolocationid| dispatching_base_num | pickup_datetime | dropoff_datetime | affiliated_base_number | dolocationid |
|---|---|---|---|---|
| B00053 | 2024-01-01T00:15:00.000 | 2024-01-01T02:13:00.000 | B00014 | — |
| B00111 | 2024-01-01T00:30:00.000 | 2024-01-01T02:37:00.000 | B00111 | — |
| B00112 | 2024-01-01T00:27:24.000 | 2024-01-01T01:12:05.000 | B00112 | 14.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% | B00856B02550B01899 |
pickup_datetime | datetime | The date and time of the trip pick-up | 0% | 2024-12-05T09:00:00.0002024-11-20T09:00:00.0002024-04-09T09:00:00.000 |
dropoff_datetime | datetime | The date and time of the trip dropoff | 0% | 2024-08-29T22:56:54.0002024-08-30T22:56:54.0002024-08-28T22:56:54.000 |
pulocationid | integer | TLC Taxi Zone in which the trip began | 79% |
GET /api/datasets/gzsz-58nf GET /api/datasets/gzsz-58nf/quality GET /api/datasets/gzsz-58nf/related GET /api/columns?dataset=gzsz-58nf
pulocationiddolocationidpulocationiddolocationidpulocationiddolocationidpulocationiddolocationid| 2024-01-01T00:10:09.000 |
| 2024-01-01T00:25:39.000 |
| B00112 |
| 133.0 |
| B00112 | 2024-01-01T00:57:07.000 | 2024-01-01T01:05:04.000 | B00112 | 14.0 |
| B00112 | 2024-01-01T00:50:18.000 | 2024-01-01T01:29:31.000 | B00112 | 91.0 |
| B00112 | 2024-01-01T00:11:16.000 | 2024-01-01T00:11:21.000 | B00112 | 14.0 |
| B00112 | 2024-01-01T00:38:29.000 | 2024-01-01T00:47:47.000 | B00112 | 14.0 |
| B00112 | 2024-01-01T00:51:36.000 | 2024-01-01T00:58:14.000 | B00112 | 14.0 |
| B00112 | 2024-01-01T00:36:54.000 | 2024-01-01T00:37:10.000 | B00112 | 67.0 |
206.0221.092.0dolocationid | integer | TLC Taxi Zone in which the trip ended | 17% | 76.0265.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 | 1% | B03404B01899B03164 |