From a 500-row sample across 6 columns.
dispatching_base_numsr_flagpickup_datetime+4dispatching_base_numsr_flagpickup_datetime+3dispatching_base_numsr_flagpickup_datetime+3dolocationidpulocationid| dispatching_base_num | pickup_datetime | dropoff_datetime | affiliated_base_number | dolocationid |
|---|---|---|---|---|
| B00001 | 2023-03-01T00:24:00.000 | 2023-03-01T02:35:00.000 | B00001 | — |
| B00008 | 2023-01-01T00:30:00.000 | 2023-01-01T01:00:00.000 | B00008 | — |
| B00078 | 2023-01-01T00:01:00.000 | 2023-01-01T03:15:00.000 | B00078 | — |
| B00111 |
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% | B03380B02550B00856 |
pickup_datetime | datetime | The date and time of the trip pick-up | 0% | 2023-12-12T21:00:00.0002023-12-13T09:00:00.0002023-09-14T13:00:00.000 |
dropoff_datetime | datetime | The date and time of the trip dropoff | 0% | 2023-11-14T13:00:00.0002023-10-18T09:00:00.0002023-06-27T12:00:00.000 |
pulocationid | integer | TLC Taxi Zone in which the trip began | 78% |
GET /api/datasets/ywip-y6qr GET /api/datasets/ywip-y6qr/quality GET /api/datasets/ywip-y6qr/related GET /api/columns?dataset=ywip-y6qr
dolocationidpulocationidpickup_datetimedropoff_datetimedolocationidpulocationid| 2023-01-01T00:30:00.000 |
| 2023-01-01T01:05:00.000 |
| B03406 |
| — |
| B00112 | 2023-01-01T00:34:45.000 | 2023-01-01T00:52:03.000 | B00112 | 14.0 |
| B00112 | 2023-01-01T00:11:20.000 | 2023-01-01T00:22:03.000 | B00112 | 14.0 |
| B00112 | 2023-01-01T00:33:28.000 | 2023-01-01T00:53:46.000 | B00112 | 29.0 |
| B00112 | 2023-01-01T00:33:11.000 | 2023-01-01T00:48:45.000 | B00112 | 14.0 |
| B00112 | 2023-01-01T00:55:24.000 | 2023-01-01T01:02:55.000 | B00112 | 14.0 |
| B00112 | 2023-01-01T00:39:16.000 | 2023-01-01T00:39:23.000 | B00112 | 14.0 |
206.0221.092.0dolocationid | integer | TLC Taxi Zone in which the trip ended | 18% | 265.076.026.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" | 2% | B03404B03380B01899 |