From a 500-row sample across 25 columns.
hvfhs_license_numdolocationidshared_request_flag+21hvfhs_license_numdolocationidpickup_datetime+3dolocationidpickup_datetimepulocationid+2| 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 | 2025-01-01T00:28:07.000 | 2025-01-01T00:31:17.000 | 2025-01-01T00:33:25.000 | 2025-01-01T00:54:24.000 | 148 | 211 | 1.32 | 1259 | 18.21 |
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 | categorical | The TLC Base License Number of the base that dispatched the trip | 0% | B03404B03406of 2 |
originating_base_num | categorical | Number of the base that received the original trip request | 28% | B03404B03406B02026of 7 |
request_datetime | datetime | date/time when passenger requested to be picked up | 0% | 2025-11-02T05:00:00.000 |
GET /api/datasets/nt46-nv3c GET /api/datasets/nt46-nv3c/quality GET /api/datasets/nt46-nv3c/related GET /api/columns?dataset=nt46-nv3c
dolocationidpickup_datetimepulocationid+2dolocationidpulocationiddolocationidairport_feepulocationid+1dolocationidpulocationidcongestion_surchargedolocationidairport_feepulocationid+1| HV0005 | B03406 | — | 2025-01-01T00:18:33.000 | — | 2025-01-01T00:29:49.000 | 2025-01-01T00:41:52.000 | 127 | 244 | 3.313 | 723 | 16.97 |
| HV0003 | B03404 | B03404 | 2025-01-01T00:28:22.000 | 2025-01-01T00:31:52.000 | 2025-01-01T00:32:39.000 | 2025-01-01T01:20:33.000 | 132 | 181 | 13.43 | 2874 | 40.36 |
| HV0003 | B03404 | B03404 | 2025-01-01T00:27:13.000 | 2025-01-01T00:33:58.000 | 2025-01-01T00:34:55.000 | 2025-01-01T00:39:19.000 | 76 | 76 | 0.82 | 264 | 12.24 |
| HV0003 | B03404 | B03404 | 2025-01-01T00:33:29.000 | 2025-01-01T00:45:46.000 | 2025-01-01T00:46:19.000 | 2025-01-01T00:53:56.000 | 76 | 76 | 1.61 | 457 | 19.76 |
| HV0003 | B03404 | B03404 | 2025-01-01T00:34:43.000 | 2025-01-01T00:45:29.000 | 2025-01-01T00:45:50.000 | 2025-01-01T01:20:23.000 | 112 | 89 | 9.66 | 2073 | 29.5 |
| HV0003 | B03404 | B03404 | 2025-01-01T00:21:17.000 | 2025-01-01T00:24:00.000 | 2025-01-01T00:25:37.000 | 2025-01-01T00:42:44.000 | 236 | 235 | 6.95 | 1027 | 22.35 |
| HV0003 | B03404 | B03404 | 2025-01-01T00:27:27.000 | 2025-01-01T00:32:50.000 | 2025-01-01T00:34:51.000 | 2025-01-01T01:23:02.000 | 90 | 242 | 14.15 | 2891 | 38.87 |
| HV0005 | B03406 | — | 2025-01-01T00:10:48.000 | — | 2025-01-01T00:12:35.000 | 2025-01-01T00:51:37.000 | 234 | 41 | 7.254 | 2342 | 33.49 |
| HV0005 | B03406 | — | 2025-01-01T00:47:41.000 | — | 2025-01-01T00:58:49.000 | 2025-01-01T01:55:23.000 | 41 | 188 | 16.748 | 3394 | 92.93 |
Showing 12 of 25 columns. All of them are listed below.
2025-11-19T09:10:00.0002025-09-26T05:00:00.000on_scene_datetime | datetime | date/time when driver arrived at the pick-up location (Accessible Vehicles-only) | 4% | 2025-06-25T08:01:22.0002025-06-25T08:01:23.0002025-05-27T12:13:29.000 |
pickup_datetime | datetime | The date and time of the trip pick-up | 0% | 2025-02-19T08:00:00.0002025-02-12T07:30:00.0002025-02-12T08:00:00.000 |
dropoff_datetime | datetime | The date and time of the trip drop-off | 0% | 2025-11-02T01:00:41.0002025-11-02T01:08:43.0002025-11-02T01:06:11.000 |
pulocationid | integer | TLC Taxi Zone in which the trip began | 0% | 13813261 |
dolocationid | integer | TLC Taxi Zone in which the trip ended | 0% | 265138132 |
trip_miles | float | total miles for passenger trip | 0% | 1.141.131.15 |
trip_time | integer | total time in seconds for passenger trip | 0% | 578553555 |
base_passenger_fare | float | base passenger fare before tolls, tips, taxes, and fees | 0% | 7.38.979.86 |
tolls | float | total amount of all tolls paid in trip | 0% | 0.06.9416.06 |
bcf | float | total amount collected in trip for Black Car Fund | 0% | 0.220.290.24 |
sales_tax | float | total amount collected in trip for NYS sales tax | 0% | 0.00.790.87 |
congestion_surcharge | categorical | total amount collected in trip for NYS congestion surcharge | 0% | 0.02.750.75of 7 |
airport_fee | float | $2.50 for both drop off and pick up at LaGuardia, Newark, and John F. Kennedy airports | 0% | 0.02.51.25 |
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% | 4.05.476.48 |
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% | NYof 2 |
wav_request_flag | categorical | Did the passenger request a wheelchair-accessible vehicle (WAV)? | 0% | NYof 2 |
wav_match_flag | categorical | Did the trip occur in a wheelchair-accessible vehicle (WAV)? | 0% | NYof 2 |
cbd_congestion_fee | categorical | Per-trip charge for MTA's Congestion Relief Zone starting Jan. 5, 2025 | 0% | 0.01.53.0of 4 |