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 2018

xjtr-h2x2Transportation7 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.9 / 100

From a 500-row sample across 7 columns.

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

Related datasets

  • Medallion Drivers – Passenger Assistance Trained0.47
    joins onexpiration_datenamelicense_number+2
  • For Hire Vehicles (FHV) - Active Drivers0.42
    joins onexpiration_datenamelast_time_updated+3
  • Street Hail Livery (SHL) Drivers - Active0.35
    joins onexpiration_datenamelicense_number
  • Taxi Improvement Fund (TIF) Medallion Payments0.33
    joins onlast_time_updatedlicense_numberlast_date_updated

Sample rows

license_numbernametypeexpiration_datecompleted_both_traininglast_date_updatedlast_time_updated
5785139WANG,CHUNMEDALLION TAXI DRIVER2020-05-15T00:00:00.000YES2018-12-31T00:00:00.00013:20
5507047LAMA,CHHIRING,RMEDALLION TAXI DRIVER2020-05-11T00:00:00.000YES2018-12-31T00:00:00.00013:20
5643204MOUSA,SEFAN,MOUSA,BOTROS

Columns

7 queryable · 7 profiled

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

FieldTypeDescriptionNullValues
license_numberinteger—0%40894551410245150570
nametext—0%SINGH,GURPREETSINGH,JASWINDERSINGH,MANPREET
typetext—0%MEDALLION TAXI DRIVERof 1
expiration_datedatetime—0%2020-02-08T00:00:00.0002020-03-17T00:00:00.0002020-11-30T00:00:00.000
completed_both_training

Query this from your own app

GET /api/datasets/xjtr-h2x2
GET /api/datasets/xjtr-h2x2/quality
GET /api/datasets/xjtr-h2x2/related
GET /api/columns?dataset=xjtr-h2x2
Medallion Vehicles - Inactive
0.30
joins onnamelicense_numbertype
  • Historical Driver Application Status0.30
    joins ontype
  • Bicycle Counters (Historical)0.29
    joins onname
  • TLC New Driver Application Status0.29
    joins ontype
    • MEDALLION TAXI DRIVER
    2019-11-06T00:00:00.000
    YES
    2018-12-31T00:00:00.000
    13:20
    5665228ZAMANI,SHAHRAM,KMEDALLION TAXI DRIVER2020-04-03T00:00:00.000YES2018-12-31T00:00:00.00013:20
    5052697BALDOCEDA,RAFAEL,MMEDALLION TAXI DRIVER2019-08-28T00:00:00.000YES2018-12-31T00:00:00.00013:20
    5418385SAYEEDIN,A-K-M,MOKSUDUSMEDALLION TAXI DRIVER2020-02-28T00:00:00.000YES2018-12-31T00:00:00.00013:20
    5882006ISAEV,MAKSIMMEDALLION TAXI DRIVER2021-09-06T00:00:00.000YES2018-12-31T00:00:00.00013:20
    5683198SMITH,DARRYL,WMEDALLION TAXI DRIVER2019-04-29T00:00:00.000YES2018-12-31T00:00:00.00013:20
    5408298HOQUE,MOHAMMAD,SHAMIMULMEDALLION TAXI DRIVER2019-09-08T00:00:00.000YES2018-12-31T00:00:00.00013:20
    5863575NFN,GULZARMEDALLION TAXI DRIVER2021-04-05T00:00:00.000YES2018-12-31T00:00:00.00013:20
    text
    —
    0%
    YESof 1
    last_date_updateddatetime—0%2018-08-01T00:00:00.0002018-10-22T00:00:00.0002018-12-03T00:00:00.000
    last_time_updatedcategorical—0%13:2023:30of 2