About this Dataset

Public Passenger Vehicle Licenses - Historical

NOT CURRENT DATA - This dataset contains past records from the Public Passenger Vehicle Licenses dataset. It is intended for historical reference, not current licensing information. It follows the format of the Public Passenger Vehicle Licenses dataset, with the addition of two additional columns at the end. The Last Valid Date column indicates the most recent timestamp when that set of values appeared in the Public Passenger Vehicle Licenses dataset. It indicates when that version of the license record stopped being valid (was replaced by an updated version), not when it started being valid (replaced a previous version or was created for a newly added license). Due to various technical limitations, the Last Valid Date may be artificially late and intervening versions not shown are possible. The Record Version ID is a unique identifier that has no meaning beyond distinguishing different versions of the same RecordID. Please read the article linked below for more information. Due to a change in the source system on 11/19/2018, all licenses will appear to have been updated on that date or on 11/20/2018.
Organization: City of Chicago
Last updated: 2024-08-09T19:13:22.933953
Tags: historical, licenses, link-to-article-present, taxis, transportation, vehicles

Tables

Table 1

@usgov.city_of_chicago_public_passenger_vehicle_licenses_historical.table_1

6.13 MB
104415 rows
19 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,
  "last_valid_date" VARCHAR,
  "record_version_id" VARCHAR
);