Dataset: Transportation Network Providers - Trips (2018 - 2022)

About this Dataset

Transportation Network Providers - Trips (2018 - 2022)

This dataset ends with 2022. Please see the Featured Content link below for the dataset that starts in 2023. All trips, from November 2018 to December 2022, reported by Transportation Network Providers (sometimes called rideshare companies) to the City of Chicago as part of routine reporting required by ordinance. Census Tracts are suppressed in some cases, and times are rounded to the nearest 15 minutes. Fares are rounded to the nearest $2.50 and tips are rounded to the nearest $1.00. For a discussion of the approach to privacy in this dataset, please see https://data.cityofchicago.org/stories/s/82d7-i4i2.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:08.420894
Tags: 2018, 2019, 2020, 2021, 2022, historical, rideshare, tnp, transportation, transportation-network-provider, trips

Tables

Table 1

@usgov.city_of_chicago_transportation_network_providers_trips.table_1

886.49 MB
16359002 rows
21 columns


CREATE TABLE table_1 (
  "trip_id" VARCHAR,
  "trip_start_timestamp" VARCHAR,
  "trip_end_timestamp" VARCHAR,
  "trip_seconds" DOUBLE,
  "trip_miles" DOUBLE,
  "pickup_census_tract" DOUBLE,
  "dropoff_census_tract" DOUBLE,
  "pickup_community_area" DOUBLE,
  "dropoff_community_area" DOUBLE,
  "fare" DOUBLE,
  "tip" DOUBLE,
  "additional_charges" DOUBLE,
  "trip_total" DOUBLE,
  "shared_trip_authorized" VARCHAR,
  "trips_pooled" DOUBLE,
  "pickup_centroid_latitude" VARCHAR,
  "pickup_centroid_longitude" DOUBLE,
  "pickup_centroid_location" VARCHAR,
  "dropoff_centroid_latitude" DOUBLE,
  "dropoff_centroid_longitude" DOUBLE,
  "dropoff_centroid_location" VARCHAR
);