<b>NOT CURRENT DATA</b> - This dataset contains <b>past</b> records from the <a href="https://data.cityofchicago.org/d/tfm3-3j95"> Public Passenger Vehicle Licenses dataset</a>. 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 <b>stopped</b> being valid (was replaced by an updated version), not when it <b>started</b> 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.
This dataset has the following 19 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Vehicle Type | vehicle_type | text | Type of Public Passenger Vehicle license issued | Taxi Livery Charter Sightseeing Ambulance Pedicab view top 100 |
| Public Vehicle Number | public_vehicle_number | number | Assigned License Number. For Taxi type licenses, this number is also the corresponding medallion number. | 19 23 15 16 20 view top 100 |
| Status | status | text | Status of the license. | ACTIVE VIOLATION SURRENDER INACTIVE FORECLOSURE view top 100 |
| Vehicle Make | vehicle_make | text | Make of the vehicle associated with the license. | TOYOTA FORD LINCOLN CHEVROLET NISSAN view top 100 |
| Vehicle Model | vehicle_model | text | Model of the vehicle associated with the license. | CAMRY PRIUS ESCAPE SUBURBAN ALTIMA view top 100 |
| Vehicle Model Year | vehicle_model_year | number | Model year of the vehicle associated with the license. | 2014 2013 2012 2011 2015 view top 100 |
| Vehicle Color | vehicle_color | text | Color of the vehicle associated with the license. | BLACK WHITE YELLOW BLUE/WHITE ORANGE/BLUE view top 100 |
| Vehicle Fuel Source | vehicle_fuel_source | text | Type of fuel used by the vehicle associated with the license. | Hybrid Gasoline Flex Fuel Compressed Natural Gas Pedal view top 100 |
| Wheelchair Accessible | wheelchair_accessible | text | Only applies to Taxi type licenses. Yes or No to indicate if the taxi vehicle is a wheelchair accessible vehicle (WAV) or not. | N Y view top 100 |
| Company Name | company_name | text | The legal owner/holder of the license. | LUCKY LIVERY INC LIMOZONE INC. DDSSBOS LLC SUPERIOR AIR-GROUND AMBULANCE SERVICE, INC. JKS LIMOUSINES LLC. view top 100 |
| Address | address | text | Company address | 3351 W. ADDISON ST. 9696 W. FOSTER AVE. 3800 N. MILWAUKEE AVE. 2617 S. WABASH AVE. 4536 N. ELSTON AVE. view top 100 |
| City | city | text | Company city | CHICAGO ELMHURST SKOKIE TINLEY PARK MOKENA view top 100 |
| State | state | text | Company state | IL WI view top 100 |
| ZIP Code | zip_code | text | Company ZIP Code | 60618 60630 60656 60659 60641 view top 100 |
| Taxi Affiliation | taxi_affiliation | text | Only applies to Taxi type licenses. The association the taxi vehicle is affiliated with. | Yellow Cab Association Independent1 Flash Cab Co DIS-AFFILIATED Yellow Cab Affiliation Inc view top 100 |
| Taxi Medallion License Management | taxi_medallion_license_management | text | Only applies to Taxi type licenses. Description of who manages the taxicab and medallion license. | Owner Manager Owner-Operator Taxi Medallion Management, LLC Medallion Leasing and Management, Inc. Chicago Elite Cab Corp. view top 100 |
| Record ID | record_id | text | A unique ID for each license in this dataset. It is a combination of the Public Vehicle Number and Vehicle Type. | 2141Taxi 5867Taxi 972Taxi 3654Taxi 1121Taxi view top 100 |
| Last Valid Date | last_valid_date | calendar_date | The last date on which this version of the record appeared. It indicates when this version STOPPED being valid (or is the last refresh time of this dataset for current records). See dataset description for more discussion of this column. | 2022-04-27T09:00:15.000 2019-04-22T03:00:20.000 2017-02-23T03:00:17.000 2020-05-25T03:00:14.000 2018-05-18T03:00:12.000 view top 100 |
| Record Version ID | record_version_id | text | A unique identifier used to distinguish different versions of the same RecordID. | 0000bffbbe77e6f7fd1a0b51b02a7266f3bb6190 00012a0153025a7ee4f862ebd971baa2723a5278 0001facef5073b30726dc47b0a10f5c18b2412a8 000366ecaaeca6a10728f9e2bd4926b47be1597e 00039658ab0afd7e57b98b9c7d57373f13a61f9f view top 100 |