About this Dataset

Public Passenger Vehicle Licenses

A public passenger vehicle is a vehicle used for the transportation of passengers for hire by a public chauffeur. The list of public passenger vehicles includes licensed taxicabs (medallions), liveries, ambulances, medicars, charter-sightseeing buses, horse-drawn carriages, and pedicabs. For more information, please see https://www.chicago.gov/city/en/depts/bacp/provdrs/vehic.html.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:26.179923
Tags: licenses, link-to-article-present, taxis, transportation, vehicles

Tables

Table 1

@usgov.city_of_chicago_public_passenger_vehicle_licenses.table_1

496.54 KB
15715 rows
17 columns


CREATE TABLE table_1 (
  "vehicle_type" VARCHAR,
  "public_vehicle_number" BIGINT,
  "status" VARCHAR,
  "vehicle_make" VARCHAR,
  "vehicle_model" VARCHAR,
  "vehicle_model_year" DOUBLE,
  "vehicle_color" VARCHAR,
  "vehicle_fuel_source" VARCHAR,
  "wheelchair_accessible" VARCHAR,
  "company_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "taxi_affiliation" VARCHAR,
  "taxi_medallion_license_management" VARCHAR,
  "record_id" VARCHAR
);