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) Permits

yhuu-4pt3Transportation20 columns
PLEASE NOTE: This dataset of all authorized Street Hail Livery Permits 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: Active Medallion and Street Hail Livery Permits This is a list of NYC TLC authorized Street Hail Livery Permits. 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. Reason Code: G – Good Standing, A – Problem with Permit, B – Problem with Base and C – Problem with Vehicle.
View on NYC Open Data↗

Quality

A94.9 / 100

From a 500-row sample across 19 columns.

completeness88/ 25% weight
consistency89/ 20% weight
accuracy100/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Medallion Vehicles - Inactive0.56
    joins onnamelicense_numbervehicle_vin_number+4
  • Medallion Vehicles - Authorized0.55
    joins onnamelicense_numbervehicle_vin_number+2
  • Street Hail Livery (SHL) Drivers - Active0.54
    joins onnamelicense_number
  • For Hire Vehicles (FHV) - Active0.53
    joins onbase_namenamebase_telephone_number+9

Sample rows

activelicense_numbernamelicense_typelicense_statusdmv_license_plate_numbervehicle_vin_numbercertification_datehack_up_datevehicle_yearbase_numberbase_name
YESAA139MIAH,MUJTABA2028-06-28T00:00:00.0006131567T147458CJTMDJREV5HD10079801/30/202601/30/20202017B03036ZYNC INC

Columns

20 queryable · 20 profiled

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

FieldTypeDescriptionNullValues
activecategoricalPermit active or not0%YESNOof 2
license_numbertextPermit License Number0%AE070AB942AE022
nametextOwner Name0%SINGH,SATNAMRAHMAN,MOHAMMED,MSINGH,JASBIR
license_typedatetimeExpiration Date0%2028-10-24T00:00:00.0002028-10-15T00:00:00.0002028-10-16T00:00:00.000

Query this from your own app

GET /api/datasets/yhuu-4pt3
GET /api/datasets/yhuu-4pt3/quality
GET /api/datasets/yhuu-4pt3/related
GET /api/columns?dataset=yhuu-4pt3
  • Medallion Drivers - Active0.47
    joins onnamelicense_number
  • For Hire Vehicles (FHV) - Active Drivers0.43
    joins onnamelicense_number
  • Lost Property Contact Information0.42
    joins onbase_namenamelicense_number+2
  • Medallion Drivers – Passenger Assistance Trained0.35
    joins onnamelicense_number
  • YES
    AA460
    SINGH,SATNAM
    2028-07-17T00:00:00.000
    5111375
    T133167C
    5J6RS6H58TL011152
    01/22/2026
    01/30/2026
    2026
    B02219
    ALL QUEENS CAR & LIMOUSINE INC.
    YESAF503SIDDIQUE,MOHAMMED2028-10-31T00:00:00.0005481041T624997C2T3LWRFV8RW22400106/04/202406/05/20242024B02772TAP & RIDE,INC.
    YESBB505MOUSSA,ELSAYED,MOHAMED2027-01-16T00:00:00.0006035540T114761C5TDYK3DC8FS60495407/10/202306/06/20232015B03152EXIT LUXURY INC.
    NOAB902HUSSAIN,IMRAN2028-08-20T00:00:00.0005943879T108034C1FMCU4K32CKA5205506/05/201906/18/20192012B01614—
    NOBC124GUL,AGHA,N2028-04-25T00:00:00.0005963114T791514C4T1BB46K49U07655203/19/202003/20/20202009B03036ZYNC INC
    YESAA056ROMERO,RAUL2028-06-21T00:00:00.0005254432T133002C4T1T11BK3PU10137002/13/202501/21/20152023B00647KISS CAR SERVICE INC
    YESAE254AKRAM,IMRAN2028-10-17T00:00:00.0005991344T102963CJTMZFREV2FJ05830603/04/202203/04/20222015B01601YOURS CAR SERVICE INC
    YESBB550SANOGO,MAMADOU2027-01-21T00:00:00.0005610172T671056CKNDJ23AU5N717238003/28/202504/28/20152022B03407ZOOM TRANSIT INC
    YESAD850SINGH,DALVINDER2028-10-11T00:00:00.0005325376T517535CJTMRJREV7JD25958908/17/202608/18/20262018B02772TAP & RIDE,INC.

    Showing 12 of 17 columns. All of them are listed below.

    license_status
    text
    Vehicle License Number
    10%
    546578157872325945757
    dmv_license_plate_numbertextDMV License Plate Number10%T151932CT114898CT499727C
    vehicle_vin_numbertextVehicle VIN Number10%2LNBL8CV0BX7639794T3MWRFV5MU0371174T3ZA3BB8BU054147
    vehicle_typetextWheelchair Access Vehicle indicator97%WAVof 1
    certification_datedateCertification Date10%07/09/202602/13/202504/04/2023
    hack_up_datedateHack Up Date10%12/23/201301/08/201412/29/2023
    vehicle_yeartextVehicle Year10%201520182014
    base_numbertextBase Number1%B02932B03036B02902
    base_nametextBase Name2%GRAND TRANSPORTATION SER…ZYNC INCNY CAR & LIMO SERVICES I…
    base_telephone_numberphoneBase Telephone Number2%(718) 433-4255(718) 482-1818(718) 255-1798
    base_websitecategoricalBase Website63%WWW.GRANDLIMONY.COMWWW.NYINSURANCEB.COMWWW.RIVERSIDECARLIMO.COMof 6
    base_addresstextBase Address2%36-13 32 STREET LIC NY …12-04 44 AVENUE LIC NY …71-16 35 AVENUE JACKSON…
    suspension_reasoncategoricalReason Code A,B,C (inactive) or G (active)0%GA-CAof 8
    suspension_datetextSuspension Date100%—
    date_updateddatetimeLast Date Updated0%2026-10-12T00:00:00.000of 1
    time_updatedtextLast Time Updated0%14:00of 1