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

Street Hail Livery (SHL) Drivers - Active

5tub-eh45Transportation7 columns
PLEASE NOTE: This dataset of all TLC licensed street hail livery (SHL) drivers in good standing is updated daily between 4–7 PM. Check the “Last Update Date” to confirm it shows today’s or yesterday’s date. If it’s older, find the latest data here: Drivers List NYC TLC Licensed Street Hail Livery drivers that are currently active and in good standing and able to drive. This list is accurate to the date and time represented in the Last Date Updated and Last Time Updated fields. For inquiries about the contents of this dataset, please email licensinginquiries@tlc.nyc.gov.
View on NYC Open Data↗

Quality

A92.7 / 100

From a 500-row sample across 7 columns.

completeness100/ 25% weight
consistency71/ 20% weight
accuracy97/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Medallion Drivers - Active0.62
    joins onlicense_numbernameexpiration_date
  • For Hire Vehicles (FHV) - Active Drivers0.62
    joins onlicense_numbernameexpiration_date
  • Medallion Vehicles - Authorized0.54
    joins onlicense_numbername
  • Street Hail Livery (SHL) Permits0.54
    joins onlicense_numbername
  • For Hire Vehicles (FHV) - Active0.49

Sample rows

license_numbernamestatus_codestatus_descriptionexpiration_datelast_update_datelast_update_time
5733721SWAVY,CYRIL1SHL UNRESTRICTED2028-11-07T00:00:00.0002026-10-13T00:00:00.00014:00
5222878KHALIK,MOHAMMED,A1SHL UNRESTRICTED2028-05-19T00:00:00.0002026-10-13T00:00:00.00014:00
5390397HOWLADER,ANIMESH

Columns

7 queryable · 7 profiled

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

FieldTypeDescriptionNullValues
license_numbertextTLC Driver License Number0%608247961109045995759
nametextTLC Driver Name0%SINGH,GURPREETSINGH,MANPREETSINGH,HARPREET
status_codecategoricalStatus Code 1,2, or 3 of permit level0%13of 2
status_descriptioncategoricalStatus Description of Status Code0%SHL UNRESTRICTEDSHL WAV ONLYof 2

Query this from your own app

GET /api/datasets/5tub-eh45
GET /api/datasets/5tub-eh45/quality
GET /api/datasets/5tub-eh45/related
GET /api/columns?dataset=5tub-eh45
joins on
name
expiration_date
  • Medallion Vehicles - Inactive0.46
    joins onlicense_numbername
  • Lost Property Contact Information0.41
    joins onlicense_numbername
  • Medallion Drivers – Passenger Assistance Trained0.40
    joins onlicense_numbernameexpiration_date
    • 1
    SHL UNRESTRICTED
    2028-04-20T00:00:00.000
    2026-10-13T00:00:00.000
    14:00
    5496026RODRIGUEZ,OVALLES,OMAR,G1SHL UNRESTRICTED2028-09-17T00:00:00.0002026-10-13T00:00:00.00014:00
    6002691DEGLA,YELOGNISSE,EDOUARD1SHL UNRESTRICTED2028-10-07T00:00:00.0002026-10-13T00:00:00.00014:00
    5826849HUSSAIN,TANVEER1SHL UNRESTRICTED2026-11-09T00:00:00.0002026-10-13T00:00:00.00014:00
    5688725ALAM,SUMON1SHL UNRESTRICTED2028-08-15T00:00:00.0002026-10-13T00:00:00.00014:00
    6119703KUMAR,PARDEEP1SHL UNRESTRICTED2028-11-28T00:00:00.0002026-10-13T00:00:00.00014:00
    5097332FERNANDES,GERSON,A1SHL UNRESTRICTED2029-12-03T00:00:00.0002026-10-13T00:00:00.00014:00
    5572357HALABI,PHILIP,F1SHL UNRESTRICTED2029-10-14T00:00:00.0002026-10-13T00:00:00.00014:00
    expiration_date
    datetime
    Expiration Date
    0%
    2028-12-08T00:00:00.0002029-08-28T00:00:00.0002028-12-02T00:00:00.000
    last_update_datedatetimeLast Date Updated0%2026-10-12T00:00:00.000of 1
    last_update_timetextLast Time Updated0%14:00of 1