From a 500-row sample across 23 columns.
wav_request_flagwav_match_flagsales_tax+21wav_request_flagwav_match_flagsales_tax+21dispatching_base_numpickup_datetimedolocationid+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 | B02875 | B02875 | 2021-02-01T00:01:35.000 | 2021-02-01T00:07:53.000 | 2021-02-01T00:08:16.000 | 2021-02-01T00:25:44.000 | 244 | 262 | 5.44 | 1048 | 14.32 |
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% | HV0003HV0005HV0004of 3 |
dispatching_base_num | text | The TLC Base License Number of the base that dispatched the trip | 0% | B02510B03404B03406 |
originating_base_num | text | base number of the base that received the original trip request | 28% | B03404B02764B02872 |
request_datetime | datetime | date/time when passenger requested to be picked up | 0% | 2021-10-26T07:40:00.000 |
GET /api/datasets/5ufr-wvc5 GET /api/datasets/5ufr-wvc5/quality GET /api/datasets/5ufr-wvc5/related GET /api/columns?dataset=5ufr-wvc5
congestion_surchargedolocationidpulocationidpickup_datetimedropoff_datetimedolocationidpulocationiddispatching_base_numhvfhs_license_numpickup_datetime+3| HV0003 | B02875 | B02875 | 2021-02-01T00:23:05.000 | 2021-02-01T00:30:09.000 | 2021-02-01T00:31:46.000 | 2021-02-01T00:41:50.000 | 262 | 75 | 1.43 | 604 | 11.11 |
| HV0003 | B02875 | B02875 | 2021-02-01T00:39:42.000 | 2021-02-01T00:46:58.000 | 2021-02-01T00:47:18.000 | 2021-02-01T00:52:44.000 | 236 | 238 | 1.12 | 326 | 13.44 |
| HV0003 | B02869 | B02869 | 2021-02-01T00:00:09.000 | 2021-02-01T00:26:40.000 | 2021-02-01T00:26:40.000 | 2021-02-01T00:33:32.000 | 139 | 139 | 1.69 | 412 | 7.12 |
| HV0003 | B02869 | B02869 | 2021-02-01T00:44:03.000 | 2021-02-01T00:53:22.000 | 2021-02-01T00:53:56.000 | 2021-02-01T01:08:01.000 | 203 | 10 | 3.82 | 845 | 12.6 |
| HV0005 | B02510 | — | 2021-01-31T23:47:51.000 | — | 2021-02-01T00:04:06.000 | 2021-02-01T00:06:52.000 | 142 | 50 | 0.373 | 166 | 9.9 |
| HV0005 | B02510 | — | 2021-02-01T00:03:41.000 | — | 2021-02-01T00:10:21.000 | 2021-02-01T00:26:57.000 | 50 | 41 | 3.57 | 996 | 23.0 |
| HV0005 | B02510 | — | 2021-02-01T00:26:21.000 | — | 2021-02-01T00:38:32.000 | 2021-02-01T00:48:09.000 | 238 | 143 | 2.139 | 577 | 13.99 |
| HV0005 | B02510 | — | 2021-02-01T00:52:51.000 | — | 2021-02-01T00:57:34.000 | 2021-02-01T01:05:13.000 | 143 | 142 | 1.058 | 459 | 7.31 |
| HV0005 | B02510 | — | 2021-01-31T23:58:29.000 | — | 2021-02-01T00:09:52.000 | 2021-02-01T00:24:27.000 | 116 | 243 | 3.91 | 875 | 28.64 |
Showing 12 of 23 columns. All of them are listed below.
2021-10-26T08:10:00.0002021-10-26T07:55:00.000on_scene_datetime | datetime | date/time when driver arrived at the pick-up location (Accessible Vehicles-only) | 28% | 2021-10-18T08:48:06.0002021-10-18T08:48:05.0002021-10-18T08:48:07.000 |
pickup_datetime | datetime | The date and time of the trip pick-up | 0% | 2021-10-18T08:48:08.0002021-04-28T19:41:54.0002021-10-18T08:48:07.000 |
dropoff_datetime | datetime | The date and time of the trip drop-off | 0% | 2021-04-28T19:41:54.0002021-04-28T19:41:55.0002021-09-22T19:42:19.000 |
pulocationid | integer | TLC Taxi Zone in which the trip began | 0% | 617976 |
dolocationid | integer | TLC Taxi Zone in which the trip ended | 0% | 26561132 |
trip_miles | float | total miles for passenger trip | 0% | 1.231.311.24 |
trip_time | integer | total time in seconds for passenger trip | 0% | 558552591 |
base_passenger_fare | float | base passenger fare before tolls, tips, taxes, and fees | 0% | 7.918.048.7 |
tolls | float | total amount of all tolls paid in trip | 0% | 0.06.556.12 |
bcf | float | total amount collected in trip for Black Car Fund | 0% | 0.240.260.29 |
sales_tax | float | total amount collected in trip for NYS sales tax | 0% | 0.70.00.71 |
congestion_surcharge | categorical | total amount collected in trip for NYS congestion surcharge | 0% | 0.02.755.5of 9 |
airport_fee | coordinate | $2.50 for both drop off and pick up at LaGuardia, Newark, and John F. Kennedy airports | 21% | 0.02.55.0of 17 |
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 |