About this Dataset

Public Passenger Vehicle Inspection Schedule

Certain types of Public Passenger Vehicles licensed by the City of Chicago must be inspected as part of the license renewal or change of vehicle associated with the license. This dataset shows the schedule of upcoming appointments, as well as some past appointments.

For additional information about Public Passenger Vehicle licensing, please see https://www.chicago.gov/city/en/depts/bacp/provdrs/vehic.html.

For a list of Public Passenger Vehicle Licenses, please see https://data.cityofchicago.org/d/tfm3-3j95.

For any questions about appointments, including requests to reschedule, please e-mail BACPPV@cityofchicago.org.
Organization: City of Chicago
Last updated: 2023-04-15T10:30:01.113655
Tags: ambulance, inspections, livery, taxis, transportation, vehicles

Tables

Table 1

@usgov.city_of_chicago_public_passenger_vehicle_inspection_schedule.table_1

346.5 KB
27602 rows
14 columns


CREATE TABLE table_1 (
  "public_vehicle_type" VARCHAR,
  "public_vehicle_number" BIGINT,
  "company_name" VARCHAR,
  "vehicle_status" VARCHAR,
  "vehicle_make" VARCHAR,
  "vehicle_model" VARCHAR,
  "vehicle_model_year" BIGINT,
  "wheelchair_accessible" BOOLEAN,
  "affiliation" VARCHAR,
  "license_management" VARCHAR,
  "inspection_type" VARCHAR,
  "scheduled_inspection_date_and_time" VARCHAR,
  "result" VARCHAR,
  "current" BOOLEAN
);