From a 500-row sample across 24 columns.
pickup_datetimedropoff_datetimepulocationiddolocationidcongestion_surchargepickup_datetimedropoff_datetimepulocationiddolocationid| hvfhs_license_num | dispatching_base_num | originating_base_num | request_datetime | on_scene_datetime | pickup_datetime | dropoff_datetime | pulocationid | dolocationid | trip_miles | trip_time | base_passenger_fare |
|---|---|---|---|---|---|---|---|---|---|---|---|
| HV0003 | B03404 | B03404 | 2023-01-01T00:18:06.000 | 2023-01-01T00:19:24.000 | 2023-01-01T00:19:38.000 | 2023-01-01T00:48:07.000 | 48 | 68 | 0.94 | 1709 | 25.95 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
hvfhs_license_num | categorical | The TLC license number of the HVFHS base or business | 0% | HV0003HV0005of 2 |
dispatching_base_num | text | The TLC Base License Number of the base that dispatched the trip | 0% | B03404B03406B02764 |
originating_base_num | text | base number of the base that received the original trip request | 28% | B03404B03406B02764 |
request_datetime | datetime | date/time when passenger requested to be picked up | 0% | 2023-12-21T05:00:00.000 |
GET /api/datasets/u253-aew4 GET /api/datasets/u253-aew4/quality GET /api/datasets/u253-aew4/related GET /api/columns?dataset=u253-aew4
pulocationiddolocationidpulocationiddolocationidairport_fee+1pulocationiddolocationid| HV0003 | B03404 | B03404 | 2023-01-01T00:48:42.000 | 2023-01-01T00:56:20.000 | 2023-01-01T00:58:39.000 | 2023-01-01T01:33:08.000 | 246 | 163 | 2.78 | 2069 | 60.14 |
| HV0003 | B03404 | B03404 | 2023-01-01T00:15:35.000 | 2023-01-01T00:20:14.000 | 2023-01-01T00:20:27.000 | 2023-01-01T00:37:54.000 | 9 | 129 | 8.81 | 1047 | 24.37 |
| HV0003 | B03404 | B03404 | 2023-01-01T00:35:24.000 | 2023-01-01T00:39:30.000 | 2023-01-01T00:41:05.000 | 2023-01-01T00:48:16.000 | 129 | 129 | 0.67 | 431 | 13.8 |
| HV0003 | B03404 | B03404 | 2023-01-01T00:43:15.000 | 2023-01-01T00:51:10.000 | 2023-01-01T00:52:47.000 | 2023-01-01T01:04:51.000 | 129 | 92 | 4.38 | 724 | 20.49 |
| HV0005 | B03406 | — | 2023-01-01T00:21:34.000 | — | 2023-01-01T00:29:05.000 | 2023-01-01T00:49:54.000 | 130 | 38 | 4.921 | 1249 | 18.29 |
| HV0005 | B03406 | — | 2023-01-01T00:47:17.000 | — | 2023-01-01T00:55:29.000 | 2023-01-01T01:16:07.000 | 38 | 10 | 5.517 | 1238 | 25.76 |
| HV0003 | B03404 | B03404 | 2023-01-01T00:06:54.000 | 2023-01-01T00:08:59.000 | 2023-01-01T00:10:29.000 | 2023-01-01T00:18:22.000 | 90 | 231 | 1.89 | 473 | 14.51 |
| HV0003 | B03404 | B03404 | 2023-01-01T00:15:22.000 | 2023-01-01T00:21:39.000 | 2023-01-01T00:22:10.000 | 2023-01-01T00:33:14.000 | 125 | 246 | 2.65 | 664 | 13.0 |
| HV0003 | B03404 | B03404 | 2023-01-01T00:26:02.000 | 2023-01-01T00:39:09.000 | 2023-01-01T00:39:09.000 | 2023-01-01T01:03:50.000 | 68 | 231 | 3.26 | 1481 | 30.38 |
Showing 12 of 24 columns. All of them are listed below.
2023-11-05T05:00:00.0002023-12-21T04:00:00.000on_scene_datetime | datetime | date/time when driver arrived at the pick-up location (Accessible Vehicles-only) | 28% | 2023-09-13T19:11:27.0002023-03-11T14:03:13.0002023-03-11T14:03:07.000 |
pickup_datetime | datetime | The date and time of the trip pick-up | 0% | 2023-12-20T07:30:00.0002023-12-18T07:30:00.0002023-12-20T08:00:00.000 |
dropoff_datetime | datetime | The date and time of the trip drop-off | 0% | HV0003HV0005of 2 |
pulocationid | categorical | TLC Taxi Zone in which the trip began | 0% | HV0003HV0005of 2 |
dolocationid | categorical | TLC Taxi Zone in which the trip ended | 0% | HV0003HV0005of 2 |
trip_miles | categorical | total miles for passenger trip | 0% | HV0003HV0005of 2 |
trip_time | integer | total time in seconds for passenger trip | 0% | 558556572 |
base_passenger_fare | float | base passenger fare before tolls, tips, taxes, and fees | 0% | 7.917.868.04 |
tolls | float | total amount of all tolls paid in trip | 0% | 0.06.556.94 |
bcf | float | total amount collected in trip for Black Car Fund | 0% | 0.240.270.32 |
sales_tax | float | total amount collected in trip for NYS sales tax | 0% | 0.00.790.71 |
congestion_surcharge | categorical | total amount collected in trip for NYS congestion surcharge | 0% | 0.02.750.75of 12 |
airport_fee | categorical | $2.50 for both drop off and pick up at LaGuardia, Newark, and John F. Kennedy airports | 0% | 0.02.51.25of 19 |
tips | float | total amount of tips received from passenger | 0% | 0.03.01.0 |
driver_pay | float | total driver pay (not including tolls or tips and net of commission, surcharges, or taxes) | 0% | 5.475.395.4 |
shared_request_flag | categorical | Did the passenger agree to a shared/pooled ride, regardless of whether they were matched? | 0% | NYof 2 |
shared_match_flag | categorical | Did the passenger share the vehicle with another passenger who booked separately at any point during the trip? | 0% | NYof 2 |
access_a_ride_flag | categorical | Was the trip administered on behalf of the Metropolitan Transportation Authority (MTA)? | 0% | HV0003HV0005of 2 |
wav_request_flag | categorical | Did the passenger request a wheelchair-accessible vehicle (WAV)? | 0% | NYof 2 |
wav_match_flag | boolean | Did the trip occur in a wheelchair-accessible vehicle (WAV)? | 0% | FalseTrueof 2 |