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 2021

pxzj-y6s8Transportation7 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

C79.7 / 100

From a 500-row sample across 7 columns.

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

Related datasets

  • Medallion Drivers – Passenger Assistance Trained0.51
    joins oncompleted_both_trainingnamelicense_number+2
  • Historical Medallion Vehicles - Authorized0.48
    joins onnamelicense_numbertype
  • For Hire Vehicles (FHV) - Active Drivers0.42
    joins onlast_date_updatednamelicense_number+3
  • Medallion Drivers - Active0.39
    joins onnamelicense_numbertype+1

Sample rows

license_numbernametypeexpiration_datecompleted_both_traininglast_date_updatedlast_time_updated
5770910SINGH,MANJITMEDALLION TAXI DRIVER2023-05-30T00:00:00.000YES2021-02-03T00:00:00.00013:20
5770911POHORILYI,DANYLOMEDALLION TAXI DRIVER2023-03-28T00:00:00.000YES2021-02-03T00:00:00.00013:20
5770913

Columns

7 queryable · 7 profiled

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

FieldTypeDescriptionNullValues
license_numberinteger—0%577241354376865885376
nametext—0%SINGH,GURPREETSINGH,MANPREETSINGH,HARPREET
typetext—0%MEDALLION TAXI DRIVERof 1
expiration_datedatetime—0%2023-02-08T00:00:00.0002023-03-17T00:00:00.0002023-11-30T00:00:00.000
completed_both_training

Query this from your own app

GET /api/datasets/pxzj-y6s8
GET /api/datasets/pxzj-y6s8/quality
GET /api/datasets/pxzj-y6s8/related
GET /api/columns?dataset=pxzj-y6s8
Street Hail Livery (SHL) Drivers - Active
0.35
joins onnamelicense_numberexpiration_date
  • Taxi Improvement Fund (TIF) Medallion Payments0.35
    joins onlast_date_updatedlicense_numberlast_time_updated
  • Medallion Vehicles - Inactive0.33
    joins onnamelicense_numbertype
  • TLC New Driver Application Status0.30
    joins ontype
    • GUMANEH,SAEKO,DG
    MEDALLION TAXI DRIVER
    2023-04-08T00:00:00.000
    YES
    2021-02-03T00:00:00.000
    13:20
    5770922REYES,LEMUEL,AMEDALLION TAXI DRIVER2023-10-03T00:00:00.000YES2021-02-03T00:00:00.00013:20
    5770923CHAUDHARY,REHMANMEDALLION TAXI DRIVER2023-04-17T00:00:00.000YES2021-02-03T00:00:00.00013:20
    5770926AZAM,JAHANZEBMEDALLION TAXI DRIVER2023-06-15T00:00:00.000YES2021-02-03T00:00:00.00013:20
    5770928LORA,ANTIGUA,RAMON,EMEDALLION TAXI DRIVER2023-06-05T00:00:00.000YES2021-02-03T00:00:00.00013:20
    5770931MUSTAFAJ,VALONMEDALLION TAXI DRIVER2023-03-27T00:00:00.000YES2021-02-03T00:00:00.00013:20
    5770933LIZARDOLIZARDO,C,RMEDALLION TAXI DRIVER2023-05-01T00:00:00.000YES2021-02-03T00:00:00.00013:20
    5770934HOSSAIN,ANOWARMEDALLION TAXI DRIVER2023-03-29T00:00:00.000YES2021-02-03T00:00:00.00013:20
    text
    —
    0%
    YESof 1
    last_date_updateddatetime—0%2021-12-17T00:00:00.0002021-12-28T00:00:00.0002021-12-31T00:00:00.000
    last_time_updatedcategorical—0%13:2013:44of 2