cityofchicago/transportation-network-providers-vehicles-bc6b-sq4u

  • rideshare
  • tnp
  • transportation
  • transportation network provider
  • vehicles

Transportation Network Providers - Vehicles

Transportation Network Providers - Vehicles

All vehicles reported by Transportation Network Providers (sometimes called rideshare companies) to the City of Chicago as part of routine reporting required by ordinance. Inclusion of a vehicle in a monthly report indicates that the vehicle was eligible for trips in Chicago in that month for at least one day, regardless of whether it actually provided any rides. If a vehicle is eligible in multiple months, which is common, it will have records in each of these reporting months.

As of the creation of this dataset, there have been four TNPs licensed to operate in Chicago, although never more than three at any given time and currently three. Vehicles reported by more than one company in the same month are combined and the MULTIPLE_TNPS column is marked as TRUE. However, the matching process is imperfect so not all such vehicles are necessarily identified.

Information on last inspection date was not required before September 2017 so will not be found in older records.

The reporting is done on a monthly basis, as indicated in the MONTH_REPORTED column. However, starting in 2018, the reports are batched and files for all three months in a quarter are delivered to the City of Chicago at the end of each quarter. Due to an issue in this transition, some vehicle records for Q2 2018 (April-June) were reported for the quarter as a whole, rather than for individual months. For purposes of this dataset, those records have been assigned to 2018-06 (June). Therefore, some caution in interpreting this month and the quarter as a whole is advised.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
STATEstatestateTextThe state of the license plate
YEARyearyearNumberThe model year of the vehicle
LAST_INSPECTION_MONTHlast_inspection_monthlast_inspection_monthTextThe month in which the vehicle was last inspected for compliance with City of Chicago rules. If multiple companies reported different months, the latest month is shown.
COLORcolorcolorTextThe color of the vehicle
MODELmodelmodelTextThe model of the vehicle
MULTIPLE_TNPSmultiple_tnpsmultiple_tnpsCheckboxWhether the vehicle was reported by multiple TNPs in this month. Matching is imperfect so some vehicle records that should have been combined may be separate.
NUMBER_OF_TRIPSnumber_of_tripsnumber_of_tripsNumberNumber of trips provided in this month. Due to the complexities of matching, errors are possible in both directions. Values over 999 are converted to null as suspected error values that interfere with easy data visualization.
MONTH_REPORTEDmonth_reportedmonth_reportedTextThe month in which the vehicle was reported. If a vehicle is reported in multiple months, which is common, it will have multiple records -- one for each month.
MAKEmakemakeTextThe make of the vehicle

Upstream Metadata