Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

2022 For Hire Vehicles Trip Data

vgi6-tcdbTransportation7 columns
These records are generated from the For-Hire Vehicle (“FHV”) Trip Record submissions made by traditional livery, luxury, and black car bases. The FHV trip records include fields capturing the dispatching base license number and the pick-up date, time, and taxi zone location ID, which correspond with the NYC Taxi Zones open dataset. Each row represents a single trip in an FHV.
View on NYC Open Data↗

Quality

C74.1 / 100

From a 500-row sample across 6 columns.

completeness83/ 25% weight
consistency67/ 20% weight
accuracy100/ 20% weight
timeliness6/ 15% weight
usability95/ 20% weight

Related datasets

  • 2020 High Volume FHV Trip Records0.72
    joins onsr_flagdispatching_base_numpulocationid+3
  • 2019 High Volume FHV Trip Records0.64
    joins onsr_flagdispatching_base_numpulocationid+3
  • 2021 High Volume FHV Trip Records0.61
    joins ondispatching_base_numpulocationiddropoff_datetime+2
  • 2022 High Volume FHV Trip Records0.59
    joins ondispatching_base_numpulocationiddropoff_datetime

Sample rows

dispatching_base_numpickup_datetimedropoff_datetimeaffiliated_base_numberdolocationid
B000092022-01-01T00:31:00.0002022-01-01T01:05:00.000B00009—
B000092022-01-01T00:37:00.0002022-01-01T01:05:00.000B00009—
B000372022-01-01T00:56:37.0002022-01-01T01:06:11.000B0003785.0
B00037

Columns

7 queryable · 7 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
dispatching_base_numtextThe TLC Base License Number of the base that dispatched the trip0%B03284B00856B03380
pickup_datetimedatetimeThe date and time of the trip pick-up0%2022-02-08T09:00:00.0002022-02-18T10:00:00.0002022-12-21T09:00:00.000
dropoff_datetimedatetimeThe date and time of the trip dropoff0%2022-05-04T10:00:00.0002022-05-19T13:00:00.0002022-07-27T13:00:00.000
pulocationidintegerTLC Taxi Zone in which the trip began76%

Query this from your own app

GET /api/datasets/vgi6-tcdb
GET /api/datasets/vgi6-tcdb/quality
GET /api/datasets/vgi6-tcdb/related
GET /api/columns?dataset=vgi6-tcdb
+2
  • 2023 High Volume FHV Trip Data0.53
    joins ondispatching_base_numpulocationiddropoff_datetime+2
  • 2021 Green Taxi Trip Data0.51
    joins onpulocationiddolocationid
  • 2015 Yellow Taxi Trip Data0.50
    joins ondropoff_datetimepickup_datetime
  • 2017 Green Taxi Trip Data0.50
    joins onpulocationiddolocationid
    • 2022-01-01T00:19:54.000
    2022-01-01T00:30:47.000
    B00037
    85.0
    B000372022-01-01T00:41:49.0002022-01-01T00:52:16.000B00037188.0
    B000372022-01-01T00:21:32.0002022-01-01T00:35:06.000B0003761.0
    B000372022-01-01T00:51:19.0002022-01-01T01:08:06.000B0003776.0
    B001112022-01-01T00:30:00.0002022-01-01T01:41:00.000B03406—
    B001122022-01-01T00:31:30.0002022-01-01T01:10:06.000B0011267.0
    B001122022-01-01T00:12:26.0002022-01-01T00:37:22.000B00112155.0
    206.092.0265.0
    dolocationidintegerTLC Taxi Zone in which the trip ended16%265.076.026.0
    sr_flagtextIndicates if the trip was a part of a shared ride chain offered by a High Volume FHV company (e.g. Uber Pool, Lyft Line). For shared trips, the value is 1. For non-shared rides, this field is null.100%—
    affiliated_base_numbertext"Base number of the base with which the vehicle is affiliated. This must be provided even if the affiliated base is the same as the dispatching base"8%B03404B00900B03380