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 - Authorized

rhe8-mgbbTransportation16 columns
PLEASE NOTE: This dataset of TLC authorized medallion vehicles 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: Active Vehicles TLC authorized For-Hire vehicles that are active. 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.0 / 100

From a 500-row sample across 13 columns.

completeness92/ 25% weight
consistency85/ 20% weight
accuracy91/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Medallion Vehicles - Inactive0.76
    joins onmodel_yearlast_updated_datelast_updated_time+9
  • Medallion Drivers - Active0.74
    joins onlast_updated_datelast_updated_timelicense_number+2
  • Historical Medallion Vehicles - Authorized0.68
    joins onmodel_yearlast_updated_datelast_updated_time+13
  • For Hire Vehicles (FHV) - Active0.56

Sample rows

license_numbernametypecurrent_statusdmv_license_plate_numbervehicle_vin_numbermodel_yearmedallion_typelast_updated_datelast_updated_timeagent_numberagent_name
5D19JASVIR TAXI CORP.2027-05-31T00:00:00.000CURY202659C2T3T6RFV7PW0386562023OWNER MUST DRIVE2026-10-13T00:00:00.00014:00——

Columns

16 queryable

The machine field names SoQL needs, with the publisher's own description of each. Profiling runs nightly; null rates and sample values appear once it has.

FieldTypeDescriptionNullValues
license_numbertextMedallion License Number——
nametextMedallion Owner Name——
typedatetimeExpiration Date——
current_statustextCurrent Status——
dmv_license_plate_numbertextDMV registered vehicle plate number——
vehicle_vin_numbertextDMV registered vehicle VIN number——

Query this from your own app

GET /api/datasets/rhe8-mgbb
GET /api/datasets/rhe8-mgbb/quality
GET /api/datasets/rhe8-mgbb/related
GET /api/columns?dataset=rhe8-mgbb
joins on
dmv_license_plate_number
vehicle_vin_number
name
  • Street Hail Livery (SHL) Permits0.55
    joins ondmv_license_plate_numbervehicle_vin_numbervehicle_type+2
  • Street Hail Livery (SHL) Drivers - Active0.54
    joins onlicense_numbername
  • Medallion Drivers – Passenger Assistance Trained0.53
    joins onlast_updated_datelast_updated_timelicense_number+2
  • For Hire Vehicles (FHV) - Active Drivers0.52
    joins onlicense_numbernametype
    • 3J25
    SIMKA TAXI 26 LLC
    2027-05-31T00:00:00.000
    CUR
    Y206085C
    1FMCU9BZ0NUA67761
    2022
    NAMED DRIVER
    2026-10-13T00:00:00.000
    14:00
    354
    SEPTUAGINT SOLUTIONS LLC.
    7N78BONEHEAD LLC2027-05-31T00:00:00.000CURY205868C5TDKRKEC7SS2674692025NAMED DRIVER2026-10-13T00:00:00.00014:00000—
    7Y39SHAHJALAL RA LLC2028-05-31T00:00:00.000CURY208597C1FMCU0GN1PUB055662023NAMED DRIVER2026-10-13T00:00:00.00014:00——
    1K52GEM RIDE INC2028-05-31T00:00:00.000CURY210684C5TDKRKEC8SS2430522025NAMED DRIVER2026-10-13T00:00:00.00014:00363DHAKA EXPRESS LLC
    2V95SOMERS CHASE TAXI INC.2028-05-31T00:00:00.000CURY201463C5TDKRKEC7RS1885072024NAMED DRIVER2026-10-13T00:00:00.00014:00366I ROSENBERG AUTO REPAIRS INC
    3E50HOSSAIN,MOHAMMED,ZAFAR, HOSSAIN,MOHAMMED,ZAKIR2027-05-31T00:00:00.000CURY203173CJTMMWRFV1ND1479192022OWNER MUST DRIVE2026-10-13T00:00:00.00014:00000—
    7H92BANTA TAXI 3 LLC2028-05-31T00:00:00.000CURY103386CNM0GS9E2XL14542602020NAMED DRIVER2026-10-13T00:00:00.00014:00354SEPTUAGINT SOLUTIONS LLC.
    7J15FURIOUS TAXI INC2027-05-31T00:00:00.000CURY205220C5TDKRKEC4NS1333932022NAMED DRIVER2026-10-13T00:00:00.00014:00——
    4G67KING VERIN TAXI INC2027-05-31T00:00:00.000CURY210683C5TDKRKEC7SS2584472025NAMED DRIVER2026-10-13T00:00:00.00014:00249ON OUR WAY MANAGEMENT CORP.

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

    vehicle_typetextType of vehicle - Hybrid of Stretch limousine——
    model_yeartextModel year of the taxicab——
    medallion_typetextType of medallion whether single (independent) or multiple (fleet)——
    agent_numbertextTLC designated agent number——
    agent_nametextMedallion Agent Name——
    agent_telephone_numbertextMedallion Agent Telephone Number——
    agent_website_addresstextMedallion Agent Website Address location——
    agent_addresstextMedallion Agent Permanent Address——
    last_updated_datedatetimeData set creation date and time——
    last_updated_timetextData set creation time in 24 hour format.——