From a 500-row sample across 24 columns.
dolocationidpulocationiddolocationidpulocationidcongestion_surchargedolocationidpulocationidcongestion_surchargedolocationidairport_feepulocationid+1| 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 | 2024-01-01T00:21:47.000 | 2024-01-01T00:25:06.000 | 2024-01-01T00:28:08.000 | 2024-01-01T01:05:39.000 | 161 | 158 | 2.83 | 2251 | 45.61 |
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 | 25% | B03404B03406B03153of 9 |
request_datetime | datetime | date/time when passenger requested to be picked up | 0% | 2024-03-18T05:30:00.000 |
GET /api/datasets/bqxa-629f GET /api/datasets/bqxa-629f/quality GET /api/datasets/bqxa-629f/related GET /api/columns?dataset=bqxa-629f
dolocationidpulocationiddolocationidairport_feepulocationid+1dropoff_datetimepickup_datetimedolocationidpulocationidcongestion_surcharge| HV0003 | B03404 | B03404 | 2024-01-01T00:10:56.000 | 2024-01-01T00:11:08.000 | 2024-01-01T00:12:53.000 | 2024-01-01T00:20:05.000 | 137 | 79 | 1.57 | 432 | 10.05 |
| HV0003 | B03404 | B03404 | 2024-01-01T00:20:04.000 | 2024-01-01T00:21:51.000 | 2024-01-01T00:23:05.000 | 2024-01-01T00:35:16.000 | 79 | 186 | 1.98 | 731 | 18.07 |
| HV0003 | B03404 | B03404 | 2024-01-01T00:35:46.000 | 2024-01-01T00:39:59.000 | 2024-01-01T00:41:04.000 | 2024-01-01T00:56:34.000 | 234 | 148 | 1.99 | 930 | 17.17 |
| HV0003 | B03404 | B03404 | 2024-01-01T00:48:19.000 | 2024-01-01T00:56:23.000 | 2024-01-01T00:57:21.000 | 2024-01-01T01:10:02.000 | 148 | 97 | 2.65 | 761 | 38.67 |
| HV0003 | B03404 | B03404 | 2024-01-01T00:03:47.000 | 2024-01-01T00:05:53.000 | 2024-01-01T00:06:15.000 | 2024-01-01T00:27:53.000 | 255 | 95 | 7.02 | 1298 | 32.16 |
| HV0003 | B03404 | B03404 | 2024-01-01T00:22:51.000 | 2024-01-01T00:29:17.000 | 2024-01-01T00:29:47.000 | 2024-01-01T00:50:08.000 | 95 | 212 | 11.33 | 1221 | 45.83 |
| HV0003 | B03404 | B03404 | 2024-01-01T00:45:34.000 | 2024-01-01T00:57:29.000 | 2024-01-01T00:57:50.000 | 2024-01-01T01:11:27.000 | 213 | 47 | 3.43 | 817 | 23.23 |
| HV0003 | B03404 | B03404 | 2024-01-01T00:11:51.000 | 2024-01-01T00:15:46.000 | 2024-01-01T00:16:00.000 | 2024-01-01T00:28:13.000 | 209 | 114 | 1.54 | 733 | 15.42 |
| HV0003 | B03404 | B03404 | 2024-01-01T00:26:48.000 | 2024-01-01T00:33:02.000 | 2024-01-01T00:33:15.000 | 2024-01-01T00:46:39.000 | 113 | 209 | 1.72 | 804 | 13.65 |
Showing 12 of 24 columns. All of them are listed below.
2024-02-15T09:15:00.0002024-01-17T08:00:00.000on_scene_datetime | datetime | date/time when driver arrived at the pick-up location (Accessible Vehicles-only) | 26% | 2024-04-03T19:13:18.0002024-03-19T07:54:44.0002024-01-15T17:41:25.000 |
pickup_datetime | datetime | The date and time of the trip pick-up | 0% | 2024-01-16T07:30:00.0002024-02-29T09:00:00.0002024-01-31T07:30:00.000 |
dropoff_datetime | datetime | The date and time of the trip drop-off | 0% | 2024-04-03T19:13:18.0002024-01-15T17:41:25.0002024-03-19T07:54:50.000 |
pulocationid | integer | TLC Taxi Zone in which the trip began | 0% | 13813279 |
dolocationid | integer | TLC Taxi Zone in which the trip ended | 0% | 265132138 |
trip_miles | float | total miles for passenger trip | 0% | 1.141.131.22 |
trip_time | integer | total time in seconds for passenger trip | 0% | 578538553 |
base_passenger_fare | float | base passenger fare before tolls, tips, taxes, and fees | 0% | 8.948.958.91 |
tolls | float | total amount of all tolls paid in trip | 0% | 0.06.9420.0 |
bcf | float | total amount collected in trip for Black Car Fund | 0% | 0.250.240.32 |
sales_tax | float | total amount collected in trip for NYS sales tax | 0% | 0.790.00.95 |
congestion_surcharge | categorical | total amount collected in trip for NYS congestion surcharge | 0% | 0.02.750.75of 5 |
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% | 5.395.475.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% | 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 |