About this Dataset

Historical Medallion Vehicles - Authorized

This list contains historical information on the status of current medallion vehicles authorized to operate in New York City. This list is accurate to the date and time represented in the Last Date Updated and Last Time Updated fields. For inquiries about the contents of this dataset, please email licensinginquiries@tlc.nyc.gov. To view the latest list please visit https://data.cityofnewyork.us/Transportation/Medallion-Vehicles-Authorized/rhe8-mgbb/data.
Organization: City of New York
Last updated: 2020-11-10T17:04:38.345011
Tags: driver, limousine, medallion, taxi, taxi-driver, taxi-license, taxicab, tlc

Tables

Table 1

@usgov.city_of_new_york_historical_medallion_vehicles_authorized.table_1

318.83 MB
17,052,889 rows
16 columns

CREATE TABLE table_1 (
  "license_number" VARCHAR,
  "name" VARCHAR,
  "expiration_date" VARCHAR,
  "current_status" VARCHAR,
  "dmv_license_plate_number" VARCHAR,
  "vehicle_vin_number" VARCHAR,
  "vehicle_type" VARCHAR,
  "model_year" BIGINT,
  "medallion_type" VARCHAR,
  "agent_number" DOUBLE,
  "agent_name" VARCHAR,
  "agent_telephone_number" VARCHAR,
  "agent_website_address" VARCHAR,
  "agent_address" VARCHAR,
  "last_date_updated" TIMESTAMP,
  "last_time_updated" VARCHAR
);