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 Drivers – Passenger Assistance Trained 2014-2016

k7b3-4y4mTransportation7 columns
This list contains information on the status of current medallion drivers who had completed Passenger Assistance Training. This list is accurate to the date and time represented in the Last Date Updated and Last Time Updated fields. To view the latest list please visit https://data.cityofnewyork.us/Transportation/Medallion-Drivers-Passenger-Assistance-Trained/td5q-ry6d/
View on NYC Open Data↗

Quality

C76.3 / 100

From a 500-row sample across 7 columns.

completeness100/ 25% weight
consistency79/ 20% weight
accuracy83/ 20% weight
timeliness0/ 15% weight
usability95/ 20% weight

Related datasets

  • Medallion Drivers – Passenger Assistance Trained0.70
    joins oncompleted_both_traininglast_updated_timetype+4
  • Historical Medallion Vehicles - Authorized0.62
    joins onlast_updated_timetypelicense_number+2
  • Medallion Drivers - Active0.58
    joins onlast_updated_timetypelicense_number+3
  • Medallion Vehicles - Authorized0.45
    joins onlast_updated_timetypelicense_number+2

Sample rows

license_numbernametypeexpiration_datecompleted_both_traininglast_updated_datelast_updated_time
5724295ASAD ULLAH,SYEDMEDALLION TAXI DRIVER2019-11-01T00:00:00.000YES2016-12-31T00:00:00.00013:20
668577POLANCO,JULIO,CMEDALLION TAXI DRIVER2019-06-27T00:00:00.000YES2016-12-31T00:00:00.00013:20
5541411

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%541460154353415403357
nametextTLC Driver Name0%RAHMAN,MD,MSINGH,GURPREETSINGH,BALWINDER
typecategoricalTLC License Type0%MEDALLION TAXI DRIVERTLC DRIVERFHV DRIVERof 5
expiration_datedatetimeExpiration date of license0%2017-07-25T00:00:00.0002017-11-30T00:00:00.000

Query this from your own app

GET /api/datasets/k7b3-4y4m
GET /api/datasets/k7b3-4y4m/quality
GET /api/datasets/k7b3-4y4m/related
GET /api/columns?dataset=k7b3-4y4m
  • Medallion Vehicles - Inactive0.43
    joins onlast_updated_timetypelicense_number+2
  • For Hire Vehicles (FHV) - Active Drivers0.35
    joins ontypelicense_numbername+1
  • Taxi Improvement Fund (TIF) Medallion Payments0.34
    joins onlicense_number
  • Lost Property Contact Information0.34
    joins onlast_updated_timetypelicense_number+2
    • MONTERO-MENDOZA,JUAN,LENIN
    MEDALLION TAXI DRIVER
    2017-08-07T00:00:00.000
    YES
    2016-12-31T00:00:00.000
    13:20
    5464877MARTINEZ,ROULY,BMEDALLION TAXI DRIVER2018-01-25T00:00:00.000YES2016-12-31T00:00:00.00013:20
    5019687BOUSBACI,AHMEDMEDALLION TAXI DRIVER2020-02-20T00:00:00.000YES2016-12-31T00:00:00.00013:20
    5085946HUSSAIN,ASJADMEDALLION TAXI DRIVER2017-07-09T00:00:00.000YES2016-12-31T00:00:00.00013:20
    841322UYDESS,DAVIDMEDALLION TAXI DRIVER2019-10-02T00:00:00.000YES2016-12-31T00:00:00.00013:20
    5583389BARAL,SHOBHA,KANTAMEDALLION TAXI DRIVER2017-12-29T00:00:00.000YES2016-12-31T00:00:00.00013:20
    5396463CHOWDHURY,ZAKIRUL,HMEDALLION TAXI DRIVER2019-06-28T00:00:00.000YES2016-12-31T00:00:00.00013:20
    5573032PLACENCIA,LUCAS,EMEDALLION TAXI DRIVER2017-10-15T00:00:00.000YES2016-12-31T00:00:00.00013:20
    2017-11-26T00:00:00.000
    completed_both_trainingtextTwo training that were completed by Licensee0%YESof 1
    last_updated_datedatetimeData set creation date and time0%2016-12-08T00:00:00.0002016-12-05T00:00:00.0002016-11-28T00:00:00.000
    last_updated_timecategoricalData set creation time in 24 hour format.0%13:2013:214:56of 9