OpenData - Current Licensees List

OpenData Mine is the new location for some of the TLC’s current licensee lists. Users will now be able to use this more powerful Office-like set of tools, available online, independent of their computer system, to examine, filter, visualize and work with TLC’s licensee data in popular formats such as Excel, PDF and CSV. For application developers, OpenData provides an intuitive and flexible Application Programming Interface (API) that can be used to extend OpenData's functionality across various types of applications or hybrid systems that require TLC’s data.

• TLC publishes the current licensee lists to OpenData six days a week from Monday thru Saturday with data availability after 6 PM EST (Eastern Standard Time).
• Use the dark blue ‘filter’ button feature located near the top right of the page to search for records rather than the search text box. This will give users the most accurate results. Use of the search text box may not provide the full set of results.
• For the TLC Drivers (Medallion, Street Hail Livery and For Hire Vehicle) – Passenger Assistance Trained, Medallion Vehicles – Authorized, and Medallion Vehicles – Inactive lists, OpenData Mine contains historical results in addition to the current day’s list. When filtering your results, either input the date you are interested in or be prepared to see multiple entries for each available date.
• For the TLC Driver License (Medallion, Street Hail Livery and For Hire Vehicle) – Active lists, OpenData Mine has been updated to contain only the current day’s list.
  • To access historical information on TLC Driver License (Medallion, Street Hail Livery and For Hire Vehicle), a new TLC Driver License (Medallion, Street Hail Livery and For Hire Vehicle) – Active Change Log file is now provided. This new list contains a row for each change made to an individual Driver record, so that users can access historical information that shows how and when a Driver’s record was changed. This historical information is available from October 28th, 2013 onwards. Any change to a Driver record from October 28, 2013 onward will appear on this file.
• Stand By Vehicles (SBVs) with medallions of the format “SBV###” are now represented in the form of “V###”, for example “SBV123” will be displayed as “V123”, filter accordingly.

---

Related Documents

• Instructions on how to use OpenData Mine (PDF) for the Medallion Drivers - Trained, Medallion Vehicles - Authorized, and Medallion Vehicles - Inactive lists. (PDF)
• Instructions on how to use the new version of the OpenData Mine for the Medallion Drivers - Active list and Street Hail Livery Drivers – Active. (PDF)
• Instructions on how to use the new Medallion Drivers - Active Change Log list. (PDF)
• Instructions on how to export a file from OpenData Mine. (PDF)
• Instructions on how to use 'For Hire Vehicle Drivers - Active' list. (PDF)
• Instructions on how to use 'For Hire Vehicles - Active and Inactive' list. (PDF)

---

Yellow Medallion Taxicab Datasets on OpenData

• TLC Drivers (Medallion, Street Hail Livery and For Hire Vehicle) - Active (OpenData)
• TLC Drivers (Medallion, Street Hail Livery and For Hire Vehicle) - Passenger Assistance Trained (OpenData)
• Medallion Vehicles - Authorized (OpenData)
• Medallion Vehicles - Inactive (OpenData)

---

Street Hail Livery (SHL) Datasets on OpenData

• TLC Drivers (Medallion, Street hail Livery and For Hire Vehicle) - Active (OpenData)
• SHL Permits (OpenData)

---

For Hire Vehicle (Black Car Services, Community Car Services and Luxury Limousine Services) Datasets on OpenData

• TLC Drivers (Medallion, Street Hail Livery and For Hire Vehicle) - Active (OpenData)
• For Hire Vehicles - Active and Inactive (OpenData)