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

FHV Base Aggregate Report

2v9c-2k7fTransportation9 columns
Monthly report including total dispatched trips, total dispatched shared trips, and unique dispatched vehicles aggregated by FHV (For-Hire Vehicle) base. These have been tabulated from raw trip record submissions made by bases to the NYC Taxi and Limousine Commission (TLC). This dataset is typically updated monthly on a two-month lag, as bases have until the conclusion of the following month to submit a month of trip records to the TLC. In example, a base has until Feb 28 to submit complete trip records for January. Therefore, the January base aggregates will appear in March at the earliest. The TLC may elect to defer updates to the FHV Base Aggregate Report if a large number of bases have failed to submit trip records by the due date. Note: The TLC publishes base trip record data as submitted by the bases, and we cannot guarantee or confirm their accuracy or completeness. Therefore, this may not represent the total amount of trips dispatched by all TLC-licensed bases. The TLC performs routine reviews of the records and takes enforcement actions when necessary to ensure, to the extent possible, complete and accurate information.
View on NYC Open Data↗

Quality

A90.4 / 100

From a 500-row sample across 9 columns.

completeness91/ 25% weight
consistency72/ 20% weight
accuracy96/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • TLC Industry Indicators0.32
  • Medallion Drivers – Passenger Assistance Trained0.32
  • Medallion Vehicles - Inactive0.32
  • TLC New Driver Application Status0.31
  • For Hire Vehicles (FHV) - Active Drivers0.31
  • Medallion Taxi Initial Inspection Schedule0.31
  • Street Hail Livery (SHL) Drivers - Active0.31
  • Street Hail Livery (SHL) Permits

Sample rows

base_license_numberbase_nameyearmonthmonth_nametotal_dispatched_tripstotal_dispatched_shared_tripsunique_dispatched_vehiclesdba
B00222REYNO CAR SVC, INC.20162February5502043—
B03194SUNNY DAY TRANSPORTATION,CORP20248August7310

Columns

9 queryable · 9 profiled

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

FieldTypeDescriptionNullValues
base_license_numbertextThe TLC license number of the dispatching base0%UBERB02067B00254
base_nametextThe official name of the base entity0%SEAGULL RIDE CORPNORTHSIDE BK LLCA & S LIMOUSINE SERVICE …
dbatextThe “doing business as” name of the base80%FOUR ONES CAR SERVICEELEGANTEVELOTAX CAR SERVICE
yearcategoricalThe number of the year0%201820172019

Query this from your own app

GET /api/datasets/2v9c-2k7f
GET /api/datasets/2v9c-2k7f/quality
GET /api/datasets/2v9c-2k7f/related
GET /api/columns?dataset=2v9c-2k7f
0.31
joins onbase_name
12
SUN LIGHT CAR AND LIMO
B02594FENIX MOBILE DISPATCHERS LTD20181January36607—
B02868CHA CHA TRANSPORTATION CORP20194April144009—
B03296ZIP CONNECTIONS INC202112December18309—
B00987MARLBORO CAR SERVICE INC.20172February115109—
B02330OCHO LUXURY CAR, INC.20153March1718909ACAPOLCO EXPRESS
B03015TRI-COUNTY BLACK CARS INC20178August2882013—
B02675FRIELECH CAR & LIMO SERVICE INC20161January700715TH AVENUE CAR SERVICE
B02909PUERTO RICO EXPRESS BLACK LUXURY INC20218August103105—
of 7
monthcategoricalThe number of the week in a given year0%685of 12
month_namecategorical—0%JuneAugustMayof 12
total_dispatched_tripsintegerThe total number of dispatched trips performed in the week, to both affiliated and non‐affiliated vehicles* *Trips and unique vehicles are only counted when the base enters information into the vehicle field of the trip record.0%132
total_dispatched_shared_tripsinteger—0%0126
unique_dispatched_vehiclesintegerThe unique number of vehicles the base dispatches to in the week, including both affiliated and non‐affiliated vehicles* *Trips and unique vehicles are only counted when the base enters information into the vehicle field of the trip record.0%674