From a 500-row sample across 24 columns.
dispatching_base_numdropoff_datetimedolocationid+2dispatching_base_numdropoff_datetimedolocationid+2dispatching_base_numdropoff_datetimedolocationid+2dispatching_base_numdropoff_datetimedolocationid| 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 | 2022-01-01T00:05:31.000 | 2022-01-01T00:05:40.000 | 2022-01-01T00:07:24.000 | 2022-01-01T00:18:28.000 | 170 | 161 | 1.18 | 664 | 24.9 |
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% | 2022-10-04T07:40:00.000 |
GET /api/datasets/g6pj-fsah GET /api/datasets/g6pj-fsah/quality GET /api/datasets/g6pj-fsah/related GET /api/columns?dataset=g6pj-fsah
congestion_surchargedolocationidpulocationidcongestion_surchargedolocationidpulocationiddolocationidpulocationid| HV0003 | B03404 | B03404 | 2022-01-01T00:19:27.000 | 2022-01-01T00:22:08.000 | 2022-01-01T00:22:32.000 | 2022-01-01T00:30:12.000 | 237 | 161 | 0.82 | 460 | 11.97 |
| HV0003 | B03404 | B03404 | 2022-01-01T00:43:53.000 | 2022-01-01T00:57:37.000 | 2022-01-01T00:57:37.000 | 2022-01-01T01:07:32.000 | 237 | 161 | 1.18 | 595 | 29.82 |
| HV0003 | B03404 | B03404 | 2022-01-01T00:15:36.000 | 2022-01-01T00:17:08.000 | 2022-01-01T00:18:02.000 | 2022-01-01T00:23:05.000 | 262 | 229 | 1.65 | 303 | 7.91 |
| HV0003 | B03404 | B03404 | 2022-01-01T00:25:45.000 | 2022-01-01T00:26:01.000 | 2022-01-01T00:28:01.000 | 2022-01-01T00:35:42.000 | 229 | 141 | 1.65 | 461 | 9.44 |
| HV0003 | B03404 | B03404 | 2022-01-01T00:34:44.000 | 2022-01-01T00:36:52.000 | 2022-01-01T00:38:50.000 | 2022-01-01T00:51:32.000 | 263 | 79 | 4.51 | 762 | 17.67 |
| HV0003 | B03404 | B03404 | 2022-01-01T00:47:51.000 | 2022-01-01T00:52:00.000 | 2022-01-01T00:53:25.000 | 2022-01-01T01:08:56.000 | 113 | 140 | 3.68 | 931 | 16.68 |
| HV0003 | B03404 | B03404 | 2022-01-01T00:06:21.000 | 2022-01-01T00:06:58.000 | 2022-01-01T00:08:58.000 | 2022-01-01T00:23:01.000 | 151 | 75 | 2.77 | 843 | 14.41 |
| HV0003 | B03404 | B03404 | 2022-01-01T00:27:54.000 | 2022-01-01T00:30:26.000 | 2022-01-01T00:32:25.000 | 2022-01-01T00:44:15.000 | 263 | 229 | 2.04 | 710 | 10.64 |
| HV0003 | B03404 | B03404 | 2022-01-01T00:44:59.000 | 2022-01-01T00:48:23.000 | 2022-01-01T00:50:23.000 | 2022-01-01T01:15:30.000 | 237 | 169 | 8.79 | 1507 | 107.56 |
Showing 12 of 23 columns. All of them are listed below.
2022-05-19T07:30:00.0002022-09-13T07:40:00.000on_scene_datetime | datetime | date/time when driver arrived at the pick-up location (Accessible Vehicles-only) | 28% | 2022-09-30T19:39:39.0002022-09-30T19:32:24.0002022-12-31T22:29:05.000 |
pickup_datetime | datetime | The date and time of the trip pick-up | 0% | 2022-02-18T07:32:00.0002022-06-02T07:47:00.0002022-03-29T07:47:00.000 |
dropoff_datetime | datetime | The date and time of the trip drop-off | 0% | HV0003HV0005of 2 |
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.221.251.26 |
trip_time | integer | total time in seconds for passenger trip | 0% | 603563577 |
base_passenger_fare | float | base passenger fare before tolls, tips, taxes, and fees | 0% | 7.918.277.51 |
tolls | float | total amount of all tolls paid in trip | 0% | 0.06.5520.0 |
bcf | float | total amount collected in trip for Black Car Fund | 0% | 0.240.00.27 |
sales_tax | float | total amount collected in trip for NYS sales tax | 0% | 0.70.00.73 |
congestion_surcharge | categorical | total amount collected in trip for NYS congestion surcharge | 0% | 0.02.750.75of 11 |
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.475.45.39 |
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 | text | Was the trip administered on behalf of the Metropolitan Transportation Authority (MTA)? | 72% | Nof 1 |
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 |