About this Dataset

Medallion Vehicles - Inactive

Please Note: This dataset, which includes historical information on medallion vehicles which were not in good standing and able to drive on the date in the 'Last Update Date' field, 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_inactive.csv This list contains information on medallion vehicles that are currently inactive. The reason codes for an inactive medallion status are as follows: OOB for Out of Business, PEN for Pending, REV for Revoked, STO for In Storage and SUS for Suspended (Note: Reason for Suspension is also supplied). 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.
Organization: City of New York
Last updated: 2020-11-10T17:03:41.947681
Tags: authorized-taxi-vehicle, driver, inactive-taxi, limousine, medallion, nyc-tlc-taxi, suspended-taxi, taxi, taxi-driver, taxi-license, taxi-suspension, taxicab, tlc

Tables

Table 1

@usgov.city_of_new_york_medallion_vehicles_inactive.table_1

122.04 MB
13900390 rows
14 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" VARCHAR,
  "medallion_type" VARCHAR,
  "agent_number" DOUBLE,
  "suspension_date" TIMESTAMP,
  "suspension_reason" VARCHAR,
  "last_date_updated" TIMESTAMP,
  "last_time_updated" VARCHAR
);