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

Historical Medallion Vehicles - Authorized

pvkv-25ckTransportation16 columns
This list contains historical information on the status of current medallion vehicles authorized to operate in New York City. 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. To view the latest list please visit https://data.cityofnewyork.us/Transportation/Medallion-Vehicles-Authorized/rhe8-mgbb/data.
View on NYC Open Data↗

Quality

C77.2 / 100

From a 500-row sample across 15 columns.

completeness89/ 25% weight
consistency90/ 20% weight
accuracy85/ 20% weight
timeliness0/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Medallion Vehicles - Authorized0.68
    joins onagent_addresslast_updated_timeagent_telephone_number+13
  • Historical Medallion Drivers – Passenger Assistance Trained 2014-20160.62
    joins onlast_updated_timelast_updated_datetype+2
  • Medallion Vehicles - Inactive0.60
    joins onlast_updated_timevehicle_typelast_updated_date+9
  • Medallion Drivers – Passenger Assistance Trained0.57

Sample rows

license_numbernametypecurrent_statusdmv_license_plate_numbervehicle_vin_numbervehicle_typemodel_yearmedallion_typeagent_numberagent_nameagent_telephone_number
4D57JEAN-PIERRE, LEBON05/31/2018CUR4D57B1FMCU4K31CKA85967HYB2012NAMED DRIVER253QUEENS MEDALLION LEASING INC.(718)784-9292

Columns

16 queryable · 16 profiled

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

FieldTypeDescriptionNullValues
license_numbertextMedallion License Number0%2G503A622D24
nametextMedallion Owner Name0%CHESTER CAB CORPCLYDE CAB CORPTOPS CAB CORP
typedateExpiration Date0%MEDALLION05/31/201705/31/2016of 11
current_statustextCurrent Status0%CURof 1
dmv_license_plate_number

Query this from your own app

GET /api/datasets/pvkv-25ck
GET /api/datasets/pvkv-25ck/quality
GET /api/datasets/pvkv-25ck/related
GET /api/columns?dataset=pvkv-25ck
joins onlast_updated_timelast_updated_datetype+2
  • Medallion Drivers - Active0.50
    joins onlast_updated_timelast_updated_datetype+2
  • Historical Medallion Drivers – Passenger Assistance Trained 20180.44
    joins ontypenamelicense_number
  • Historical Medallion Drivers – Passenger Assistance Trained 20170.43
    joins ontypenamelicense_number
  • Lost Property Contact Information0.41
    joins onlast_updated_timelast_updated_datetype+2
    • 1P38
    GENNADY TAXI INC
    MEDALLION
    CUR
    1P38B
    4T1BD1FK9CU050772
    HYB
    2012
    NAMED DRIVER
    202
    —
    —
    2C36ROY,NIRMAL,CMEDALLIONCUR2C36CJTDZN3EU0EJ001169HYB2014OWNER MUST DRIVE000——
    4N82N & J TAXI INCMEDALLIONCUR4N82A2FABP7AV7BX178957—2011NAMED DRIVER292CITY TRANSPORT MGMT(718)507-4840
    3L55LUBA CAB CORPMEDALLIONCUR3L55C1N4AL3AP4DC913234—2013NAMED DRIVER307TAXIFLEET MANAGEMENT LLC(718)779-5000
    7C76JASWAL,GURMIT,SINGHMEDALLIONCUR7C76A1FMCU49369KB31002HYB2009OWNER MUST DRIVE000——
    6L81PHI CAB CORP05/31/2017CUR6L81H5TDZKRFH7ES020124—2014NAMED DRIVER000——
    3B73CHAVEZ, MIRNAMEDALLIONCUR3B73B1FMCU49H68KA36952HYB2008NAMED DRIVER259——
    4C79AHMED,SHABBIRMEDALLIONCUR4C79C1FMCU49H48KC93527HYB2008OWNER MUST DRIVE000——
    4D77WILLIAMS, PETERMEDALLIONCUR4D77A1FMCU4K33BKC32546HYB2011NAMED DRIVER000——

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

    text
    DMV registered vehicle plate number
    0%
    2K24B3Y42B4P77B
    vehicle_vin_numbertextDMV registered vehicle VIN number0%4T1BD1FK6DU081656NM0KS9CN4BT074941NM0KS9CN2BT072458
    vehicle_typecategoricalType of vehicle - Hybrid of Stretch limousine30%HYBWAVDSEof 5
    model_yeartextModel year of the taxicab0%201420122011
    medallion_typecategoricalType of medallion whether single (independent) or multiple (fleet)0%NAMED DRIVEROWNER MUST DRIVEof 2
    agent_numbertextTLC designated agent number1%000202307
    agent_nametextMedallion Agent Name46%ALL TAXI MANAGEMENT INCTAXIFLEET MANAGEMENT LLCGOTHAM YELLOW LLC
    agent_telephone_numbertextMedallion Agent Telephone Number46%(718)361-0055(718)779-5000(718)784-9292
    agent_website_addresscategoricalMedallion Agent Website Address location100%WWWW.UNITEDTAXINYC.COMMCMCTAXI.COMof 2
    agent_addresstextMedallion Agent Permanent Address46%41-25 36 STREET LIC NY…54-11 QUEENS BOULEVARD W…21-03 44 AVENUE LIC NY…
    last_updated_datedatetimeData set creation date and time1%2015-02-07T00:00:00.0002015-02-19T00:00:00.0002014-09-06T00:00:00.000
    last_updated_timecategoricalData set creation time in 24 hour format.0%13:20132014:08of 9