About this Dataset

Street Hail Livery (SHL) Permits

Please Note: This dataset, which includes all TLC authorized Street Hail Livery Permits, 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 list from the most recent link below. http://www1.nyc.gov/assets/tlc/downloads/datasets/tlc_street_hail_livery_permits.csv This is a list of NYC TLC authorized Street Hail Livery Permits. 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. Reason Code: G – Good Standing, A – Problem with Permit, B – Problem with Base and C – Problem with Vehicle.
Organization: City of New York
Last updated: 2020-11-10T17:06:24.686445
Tags: green-cab, green-taxi, shl, street-hail-livery

Tables

Table 1

@usgov.city_of_new_york_street_hail_livery_shl_permits.table_1

127.89 KB
2458 rows
20 columns


CREATE TABLE table_1 (
  "active" VARCHAR,
  "permit_license_number" VARCHAR,
  "name" VARCHAR,
  "expiration_date" TIMESTAMP,
  "vehicle_license_number" VARCHAR,
  "dmv_license_plate_number" VARCHAR,
  "vehicle_vin_number" VARCHAR,
  "vehicle_type" VARCHAR,
  "certification_date" TIMESTAMP,
  "hack_up_date" TIMESTAMP,
  "vehicle_year" DOUBLE,
  "base_number" VARCHAR,
  "base_name" VARCHAR,
  "base_telephone_number" VARCHAR,
  "base_website" VARCHAR,
  "base_address" VARCHAR,
  "reason" VARCHAR,
  "suspension_date" VARCHAR,
  "last_date_updated" TIMESTAMP,
  "last_time_updated" VARCHAR
);