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

Medallion Vehicles - Inactive

jgtb-hmpgTransportation14 columns
PLEASE NOTE: This dataset of all TLC inactive medallion vehicles is updated daily between 4–7 PM. Check the “Last Update Date” to confirm it shows today’s or yesterday’s date. Check the “Last Update Date” to confirm it shows today’s or yesterday’s date. If it’s older, find the latest data here: Vehicles List TLC authorized For-Hire vehicles that are inactive. 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

B86.2 / 100

From a 500-row sample across 14 columns.

completeness71/ 25% weight
consistency82/ 20% weight
accuracy91/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Medallion Vehicles - Authorized0.76
    joins onmedallion_typelicense_numbertype+9
  • Medallion Drivers - Active0.62
    joins onlicense_numbertypename+2
  • Historical Medallion Vehicles - Authorized0.60
    joins onmedallion_typelicense_numbertype+9
  • Street Hail Livery (SHL) Permits0.56
    joins onlicense_number

Sample rows

license_numbernametypecurrent_statusmedallion_typeagent_numbersuspension_datesuspension_reasonlast_updated_datelast_updated_time
4D82SIMKA TAXI 117 LLC2028-05-31SUSOWNER MUST DRIVE3542026-06-25T00:00:00.000LICENSING UNIT2026-10-13T00:00:00.00014:00
4L49KLARA & SIMON CAB CORP2027-05-31SUS

Columns

14 queryable · 14 profiled

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

FieldTypeDescriptionNullValues
license_numbertextMedallion License Number0%3W113E117M67
nametextMedallion Owner Name0%HAITIAN CAB CORPJIT TRANSPORT INCANMOL USA LLC
typedateExpiration Date0%2028-05-312027-05-312020-05-31
current_statustextCurrent Status0%SUSof 1
dmv_license_plate_numbertext

Query this from your own app

GET /api/datasets/jgtb-hmpg
GET /api/datasets/jgtb-hmpg/quality
GET /api/datasets/jgtb-hmpg/related
GET /api/columns?dataset=jgtb-hmpg
suspension_date
name
+4
  • For Hire Vehicles (FHV) - Active0.52
    joins onnamedmv_license_plate_numbervehicle_vin_number
  • Medallion Drivers – Passenger Assistance Trained0.50
    joins onlicense_numbertypename+2
  • For Hire Vehicles (FHV) - Active Drivers0.49
    joins onlicense_numbertypename
  • Street Hail Livery (SHL) Drivers - Active0.46
    joins onlicense_numbername
    • NAMED DRIVER
    366
    2026-06-05T00:00:00.000
    LICENSING UNIT
    2026-10-13T00:00:00.000
    14:00
    7M20JIT TRANSPORT INC2020-05-31SUSNAMED DRIVER0002024-08-26T00:00:00.000FI0034743/ALJ-TEMPORARY SUSP.2026-10-13T00:00:00.00014:00
    8L25VERY SIMILAR TAXI NINE LLC2027-05-31SUSNAMED DRIVER—2026-05-20T00:00:00.000LICENSING UNIT2026-10-13T00:00:00.00014:00
    5N72MILL BASIN FAMILY PARTNERS VII LLC2026-05-31SUSNAMED DRIVER3582025-12-15T00:00:00.000LICENSING UNIT2026-10-13T00:00:00.00014:00
    3P41WIMA TAXI CORP2024-05-31SUSNAMED DRIVER3582024-07-09T00:00:00.000LICENSING UNIT2026-10-13T00:00:00.00014:00
    7V59SOLKIM TRANSIT INC2026-05-31SUSNAMED DRIVER0002023-03-16T00:00:00.000LICENSING UNIT2026-10-13T00:00:00.00014:00
    4K98P&D CAB CORP2020-05-31SUSNAMED DRIVER0002021-03-30T00:00:00.000TIF017208/ALJ-TEMPORARY SUSP.2026-10-13T00:00:00.00014:00
    4L23TAHITIAN TAXI INC2023-05-31SUSNAMED DRIVER0002024-06-03T00:00:00.000RF0013377/ALJ-TEMPORARY SUSP.2026-10-13T00:00:00.00014:00
    7B857B85 TAXI LLC2028-05-31SUSOWNER MUST DRIVE3582026-07-14T00:00:00.000LICENSING UNIT2026-10-13T00:00:00.00014:00
    DMV License Plate Number
    95%
    3W11HY205381CY200787C
    vehicle_vin_numbertextVehicle VIN Number95%5TDZK3DCXES478633JTMRJREV6HD0888935TDZK3DC6GS761033
    vehicle_typetextVehicle Type98%WAVof 1
    model_yearcategoricalModel Year95%201420162015of 13
    medallion_typecategoricalMedallion Type0%NAMED DRIVEROWNER MUST DRIVEof 2
    agent_numbertextAgent Number18%000358312
    suspension_datedatetimeSuspension Date2%2024-07-09T00:00:00.0002025-07-14T00:00:00.0002026-09-02T00:00:00.000
    suspension_reasontextSuspension Reason2%LICENSING UNITINQUESTALJ-TEMPORARY SUSP.
    last_updated_datedatetimeLast Date Updated0%2026-10-12T00:00:00.000of 1
    last_updated_timetextLast Time Updated0%14:00of 1