From a 500-row sample across 12 columns.
other_requirementsdrug_testapp_no+8typetypetype| app_no | type | app_date | status | fru_interview_scheduled | drug_test | wav_course | defensive_driving | driver_exam | medical_clearance_form | other_requirements | lastupdate |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 6151986 | HDR | 2026-09-04T00:00:00.000 | Incomplete | Not Applicable | Needed | Needed | Needed | Needed | Needed | Fingerprints needed; Copy of DMV license needed | 2026-10-11T11:00:01.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
app_no | integer | This is the number linked to your application. Once your application has been approved this will become your license number. | 0% | 615470761483056147050 |
type | categorical | This is the classification of license you have applied for. HDR: Medallion /For-Hire Vehicle Operator. PDR: Paratransit Vehicle Operator. VDR: Commuter Van Vehicle Operator | 0% | HDRPDRVDRof 3 |
app_date | datetime | The date you submitted your application. | 0% | 2026-08-24T00:00:00.0002026-09-14T00:00:00.0002026-09-28T00:00:00.000 |
status | categorical | "Incomplete": Your application is missing requirements. "Pending Fitness Interview": Your application has been forwarded to the Fitness Review Unit for a Fitness Interview. "Denied": Your application has been denied. "Under Review": Your application is still being processed. "Approved - License Issued": Your application has been approved and your license will be mailed to the address provided on your application. Allow up to two weeks after approval for delivery. |
GET /api/datasets/dpec-ucu7 GET /api/datasets/dpec-ucu7/quality GET /api/datasets/dpec-ucu7/related GET /api/columns?dataset=dpec-ucu7
type| 6156227 |
| HDR |
| 2026-10-10T00:00:00.000 |
| Incomplete |
| Not Applicable |
| Needed |
| Needed |
| Needed |
| Needed |
| Needed |
| Fingerprints needed; Copy of DMV license needed |
| 2026-10-11T11:00:01.000 |
| 6155475 | HDR | 2026-10-03T00:00:00.000 | Incomplete | Not Applicable | Needed | Needed | Needed | Needed | Complete | Copy of DMV license needed | 2026-10-11T11:00:01.000 |
| 6151944 | HDR | 2026-09-04T00:00:00.000 | Approved - License Issued | Not Applicable | Complete | Complete | Complete | Complete | Complete | Not Applicable | 2026-10-11T11:00:01.000 |
| 6148100 | HDR | 2026-07-29T00:00:00.000 | Approved - License Issued | Not Applicable | Complete | Complete | Complete | Complete | Complete | Not Applicable | 2026-10-11T11:00:01.000 |
| 6153166 | HDR | 2026-09-14T00:00:00.000 | Incomplete | Not Applicable | Needed | Complete | Complete | Complete | Needed | Fingerprints needed; Copy of DMV license needed | 2026-10-11T11:00:01.000 |
| 6145992 | HDR | 2026-07-06T00:00:00.000 | Under Review | Not Applicable | Complete | Complete | Complete | Complete | Complete | Not Applicable | 2026-10-11T11:00:01.000 |
| 6151365 | HDR | 2026-08-28T00:00:00.000 | Approved - License Issued | Not Applicable | Complete | Complete | Complete | Complete | Complete | Not Applicable | 2026-10-11T11:00:01.000 |
| 6150354 | HDR | 2026-08-20T00:00:00.000 | Incomplete | Not Applicable | Complete | Complete | Complete | Needed | Needed | Copy of DMV license needed | 2026-10-11T11:00:01.000 |
| 6155066 | HDR | 2026-09-30T00:00:00.000 | Incomplete | Not Applicable | Complete | Needed | Complete | Needed | Needed | Not Applicable | 2026-10-11T11:00:01.000 |
| 0% |
IncompleteApproved - License Issue…Deniedof 5 |
fru_interview_scheduled | date | Fitness Review Unit Interview: “Not Applicable” if no Fitness Review is necessary. OR If there is a date, a Fitness Interview has been scheduled. Watch your mail/email for more information. | 0% | Not Applicable10/06/202609/03/2026of 5 |
drug_test | categorical | Drug testing is required for Medallion and FHV TLC driver’s licenses. "Needed": You must take and pass a drug test at an approved testing facility. “Not Applicable”: If you applied for a Paratransit or Commuter Van license you do not need to take a TLC Drug Test. “Complete”: Your drug test information has been received and updated in your TLC record. | 0% | NeededCompleteNot Applicableof 3 |
wav_course | categorical | Wheelchair Accessible Vehicle Training (WAV) is a requirement for those who apply for a Medallion or For-Hire Vehicle driver’s license. “Needed”: You must take the Wheelchair Accessible Vehicle Training Course within 90 days from the date you submitted your application. “Not Applicable”: If you applied for a Paratransit or Commuter Van license you will not need to take this training. “Complete”: Your WAV training information has been received and updated in your TLC record. | 0% | CompleteNeededNot Applicableof 3 |
defensive_driving | categorical | A NYS certified 6 hour Defensive Driving Course is a requirement to receive your TLC license. | 0% | CompleteNeededNot Applicableof 3 |
driver_exam | categorical | Upon Completion of TLC Driver Training (Taxi School), you will need to take and pass a final exam. Passing score is 70%. “Needed”: Your TLC Driver Exam information is not in our system. If you have not taken your TLC Driver Exam please do so. “Not Applicable”: If you applied for a Paratransit or Commuter Van license you will not need to take this exam. “Complete”: Your TLC Driver Exam information has been received and updated in your TLC record | 0% | NeededCompleteNot Applicableof 3 |
medical_clearance_form | categorical | A Medical Clearance form from a licensed medical doctor is a requirement for those who apply for a Medallion or a For-Hire Vehicle driver’s license. If the entry is: “Needed”: Your Medical Clearance form is not in our system. If you have not been medically cleared by a licensed medical doctor please do so immediately. “Not Applicable”: If you applied for a Paratransit or Commuter Van license you will not need to take this step as it is covered by your 19A status. “Complete”: Your Medical Clearan | 0% | NeededCompleteNot Applicableof 3 |
other_requirements | categorical | This field is for miscellaneous items that may need more sensitive information. Visit www.nyc.gov/tlcup for more information and to upload missing requirements. “Not Applicable”: “Other requirements” do not apply to you at this time. | 0% | Fingerprints needed; Cop…Not ApplicableCopy of DMV license need…of 8 |
lastupdate | datetime | Latest Updated Date | 0% | 2026-10-11T11:00:01.000of 1 |