About this Dataset

Public Chauffeurs

List of City of Chicago licensed Public Chauffeurs, who may operate a licensed Taxicab, Livery, or Pedicab. Horse-Drawn Carriage license historical records appear; but are no longer issued. For questions or issues regarding this dataset, please e-mail BACPPV@cityofchicago.org with chauffeur name, number, and question or issue. For more information on the Public Chauffeur program, please see http://www.cityofchicago.org/city/en/depts/bacp/supp_info/public_chauffeurinformation.html.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:34.184514
Tags: licenses, link-to-article-present, transportation

Tables

Table 1

@usgov.city_of_chicago_public_chauffeurs.table_1

935.17 kB
27,242 rows
12 columns

CREATE TABLE table_1 (
  "license_number" BIGINT,
  "renewed" VARCHAR,
  "status" VARCHAR,
  "status_date" TIMESTAMP,
  "expires" VARCHAR,
  "driver_type" VARCHAR,
  "license_type" VARCHAR,
  "original_issue_date" TIMESTAMP,
  "name" VARCHAR,
  "sex" VARCHAR,
  "chauffeur_city" VARCHAR,
  "chauffeur_state" VARCHAR
);