About this Dataset

Medallion Vehicles - Authorized

PLEASE NOTE: This dataset, which includes all TLC licensed medallion vehicles which are in good standing and able to drive, is updated every day in the evening between 4-7pm. Please check the 'Last Update Date' field to make sure the list has updated successfully. 'Last Update Date' should show either today or yesterday's date, depending on the time of day. If the list is outdated, please download the most recent list from the link below. http://www1.nyc.gov/assets/tlc/downloads/datasets/tlc_medallion_vehicles_authorized.csv **This list contains 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. For a historical data up to and including 2016, please refer to https://data.cityofnewyork.us/Transportation/Historical-Medallion-Vehicles-Authorized/pvkv-25ck/
Organization: City of New York
Last updated: 2020-11-10T17:04:58.584283
Tags: driver, limousine, medallion, taxi, taxi-driver, taxi-license, taxicab, tlc

Tables

Table 1

@usgov.city_of_new_york_medallion_vehicles_authorized.table_1

423.52 MB
30,214,003 rows
16 columns

CREATE TABLE table_1 (
  "license_number" VARCHAR,
  "name" VARCHAR,
  "expiration_date" TIMESTAMP,
  "current_status" VARCHAR,
  "dmv_license_plate_number" VARCHAR,
  "vehicle_vin_number" VARCHAR,
  "vehicle_type" VARCHAR,
  "model_year" DOUBLE,
  "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
);